Senior SQL Data DBA

Summary

Join our team as a Sr. SQL Data DBA and participate in the design, development, implementation, review, and monitoring of on-premises and cloud database environments. You will collaborate with Software Development, Data Engineering, and QA teams, ensuring efficient resource allocation and providing best-practice guidance. This fully remote position requires extensive experience with SQL Server, TSQL, and cloud services. Responsibilities include designing and implementing database servers, monitoring solutions, and security reviews, as well as assisting in TSQL development and capacity planning. You will mentor team members and contribute to project planning. The ideal candidate possesses strong SQL Server administration skills and experience with high availability and disaster recovery technologies.

Requirements

• At least 10+ years of hands-on SQL Server transactional experience
• Strong Knowledge of MS SQL Server, TSQL, Power Shell, and coding best practices
• Strong Knowledge of AWS Clouds Service(s) such as RDS and Redshift
• Experience using Source Control (GitHub) to maintain scripts and CI/CD pipelines (GitHub Actions) of databases throughout SDLC
• Strong Understanding of SQL Server high availability and disaster recovery technologies, such as availability groups, backups and restores, FCI, log shipping, mirroring, and replication
• Strong SQL Server administration skills, such as backups, restores, taking and reverting snapshots, user/role security, access permissions, etc
• Strong Understanding of SQL Server concurrency features, transactions, and locking
• Expert Experience in SQL performance analysis and optimization (tuning / optimization)
• Experience with SQL Server debugging and tracing
• Experience using Atlassian Jira & Confluence
• Familiarity with BI technologies, such as ETL, data warehousing, SSAS/OLAP, data mining, and big data technologies
• Associates degree, preferably in Computer Science or equivalent experience

Responsibilities

• Design, implement, maintain, and monitor database servers across environments including but not limited to Production, QA, and Development Environments
• Ensure High Availability and meet SLAs for systems across environments
• Design and implement monitoring solutions to achieve HA and SLA goals
• Reviews and audit all environments for best practices in security
• Assist in TSQL development (check-in, review, build, testing, and deployment) and support of SQL CI/CD life cycle
• Assist developers in best practices for writing queries / procedures
• Assist in system capacity planning
• Creates and implements new environments based on the needs of the business
• Asist in Project, Capacity, and Infrastructure Planning
• Mentor & lead team members in best practices for administration and development

Preferred Qualifications

Strong Knowledge of MySQL & Postgres preferred

Benefits

Fully Remote: This position has been designated as fully remote, meaning that the position is expected to contribute from a non-NBCUniversal worksite, most commonly an employee’s residence