Responsibilities and Deliverables
- Responsible for database design and participation in architecture/design reviews
- Create and maintain databases for labs and production usage
- Perform capacity planning for database creation and maintenance
- Conduct ongoing tuning of database instances in collaboration with development teams
- Install and upgrade databases and associated tools
- Plan and implement backup and recovery processes
- Set up replication and implement HA/DR configurations
- Manage migrations of programs, database changes, and reference data across the development lifecycle
- Implement and enforce database security standards
- Optimize database performance and ensure maximum uptime
- Collaborate with development to enforce standards for application design, code integrity, and performance
- Monitor database systems and ensure health checks are in place
- Document database designs and configurations
- Conduct impact analysis for changes to database objects
- Support and troubleshoot database and system issues via on-call rotation
Organizational Alignment
- Build, maintain, and develop collaborative relationships with cross-functional teams
Qualifications
- Skills & Work Traits
- Proactive in building and managing relationships
- Strong written and verbal communication skills
- Experience working within cross-functional teams
- Technical Competencies Required
- Strong knowledge of MS SQL, Oracle, Azure SQL, MongoDB
- Experience with cloud databases: Snowflake, Amazon RDS, RedShift, Aurora
- Proficiency in MS Clustering, Replication, HA, DR implementations
- Experience with Windows Server maintenance and administration
- Ability to implement and troubleshoot scalable, highly available systems
- Experience with backup solutions
- Technical Competencies Preferred
- Experience with IIS Server administration
- Knowledge of scripting and automation
- Experience with virtualization and cloud platforms (Azure, AWS)
- Understanding of containerization and virtualization concepts
- Basic knowledge of network protocols and storage design
- Experience with analytics, big data, or data warehouse tools (Snowflake, SSAS)
- Experience with Linux Server administration
- SQL coding proficiency
- Experience
- 5+ years of experience in Database Administration (MS SQL Server, Oracle)
- Education
- Bachelor's or Master's degree in Computer Science, Computer Engineering, or equivalent experience
- Other Requirements
- Satisfactory Criminal Background Check and Public Safety Verification required
