Description

• Develop, maintain, and optimize SQL Server stored procedures, views, functions, and advanced T-SQL solutions.
• Design, develop, and support ETL/ELT processes for enterprise data integration and transformation.
• Build and maintain data ingestion, incremental load, reconciliation, data validation, and data quality processes.
• Independently analyze, solve, and correct data, ETL, and database-related issues, providing end-to-end problem resolution.
• Maintain database objects, schema changes, and scripts using version control systems such as Azure DevOps and GitHub.
• Follow established team standards. For any gap, recommend new or updated standards and proactively identify areas for improvement.
• Document and update technical documentation, operational procedures, and support runbooks when appropriate.
• Take ownership, support, and follow-through of assigned deliverables, adjusting well to changes in priority.
• Demonstrate a willingness and commitment to learn Client's policies, procedure and standards.
• Develop accurate estimates of effort and timelines.
• Ensure that all assignments are completed accurately and within approved delivery schedules.
• Assist with query tuning, performance optimization, and schema refinement.
• Assist with SQL Server database administration activities, including monitoring, maintenance, security, backup verification, and troubleshooting.
• Serve as a backup resource for database administration support during planned absences, vacations, and off-hours support rotations.
• Work closely and effectively with business and technical teams in a cross-functional and cross-matrixed business and technical environment.
• Support release deployment activities, testing, and production implementations as required.
• Create, document, and execute test plans, including white-box testing, black-box testing, positive and negative testing.
• Other duties may be assigned, directed, or requested.

What You Will Need
• Bachelor's degree (Information Technology, Computer Science, or related field) or equivalent experience is required.
• Five (5) to eight (8) years of MS SQL Server development experience is required.
• Strong T-SQL programming experience, including complex queries, joins, views, stored procedures, functions, and query optimization are required.
• Strong experience developing and supporting ETL/ELT processes and enterprise data integrations is required.
• Experience with data ingestion, incremental loading, data validation, and data quality processes is required.
• Experience with enterprise data warehousing and dimensional modeling is required.
• Strong to advanced experience in Microsoft Excel, Word, PowerPoint, and Outlook is required.
• Experience with SQL Server performance tuning, indexes, index management, and optimization is required[SC1] Experience with PowerShell scripting and automation is a plus
• Experience with SQL Server administration, security, backup/recovery, and maintenance is a plus
• Excellent analytical, critical-thinking, and problem-solving skills, with the ability to anticipate and proactively address issues, required.
• Must have excellent communication skills, both written and verbal.
• Ability to effectively present technical concepts and information to non-technical audiences.
• Ability to prepare concise yet sufficiently detailed written communications, including documentation, deployment plans, status reports, and meeting notes, for both technical and non-technical audiences.[SC2]
• A methodical and organized approach to problem-solving

Key Skills

Education

Bachelor's degree