Full-Time Sr. SQL Data DBA - NBC Sports Next
NBCUniversal is hiring a remote Full-Time Sr. SQL Data DBA - NBC Sports Next. The career level for this job opening is Experienced and is accepting Orlando, FL based applicants remotely. Read complete job description before applying.
NBCUniversal
Job Title
Posted
Career Level
Career Level
Locations Accepted
Share
Job Details
Role DescriptionThe Sr. SQL Data DBA participates in the design, development, implementation, review, and monitoring of all on-premises and cloud database environments. The Sr. SQL Data DBA works closely with Software Development, Data Engineering, and QA teams to ensure each team has the resources needed to run efficiently and effectively and provides guidelines and recommendations on best practices.
Responsibilities
- Design, implement, maintain, and monitor database servers across environments (Production, QA, Development).
- Ensure High Availability and meet SLAs for systems across environments.
- Design and implement monitoring solutions to achieve HA and SLA goals.
- Review and audit all environments for best practices in security.
- Assist in T-SQL 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.
- Create and implement new environments based on business needs.
- Assist in Project, Capacity, and Infrastructure Planning
- Mentor & lead team members in best practices for administration and development.
Requirements
- At least 10+ years of hands-on SQL Server transactional experience.
- Strong Knowledge of MS SQL Server, T-SQL, Power Shell, and coding best practices.
- Strong Knowledge of MySQL & Postgres preferred.
- Strong Knowledge of AWS Cloud Services (RDS, 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 (availability groups, backups, restores, FCI, log shipping, mirroring, replication).
- Strong SQL Server administration skills (backups, restores, snapshots, user/role security, access permissions).
- 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 (ETL, data warehousing, SSAS/OLAP, data mining, big data).
- Associates degree, preferably in Computer Science or equivalent experience.
Remote Position
Fully Remote: This position is fully remote, and expected to contribute from a non-NBCUniversal worksite (most commonly an employee's residence).
Interview Process
In-person interview with an NBCUniversal employee at one of our locations may be required.