SQL Database Administrator
Morton
- Richmond, VA
- Permanent
- Full-time
- Administer and maintain relational databases, including DB2 and Microsoft SQL Server.
- Plan, install, configure, and upgrade database instances to ensure optimal performance.
- Design and implement enterprise-level database architectures with high availability (HA), scalability, and disaster recovery solutions.
- Develop and enforce database security policies, access controls, and encryption to protect sensitive data.
- Monitor database performance, analyze metrics, identify bottlenecks, and apply optimizations for improved query efficiency and system responsiveness.
- Automate routine database tasks using scripting languages such as Python, Ansible, and Bash.
- Execute backup, recovery, and disaster recovery plans to ensure data integrity and minimize downtime.
- Collaborate with developers and cross-functional teams to support application performance and database access requirements.
- Manage bulk data loading processes, ensuring timely and accurate data ingestion.
- Evaluate and implement database monitoring tools to proactively detect and resolve issues.
- Document database configurations, procedures, troubleshooting steps, and standards for knowledge sharing and compliance.
- Stay current with emerging database technologies, researching and recommending tools and methods to enhance database operations.
- Participate in after-hours support as needed.
- 8+ years of hands-on experience in relational database administration.
- 2+ years of experience administering DB2 databases.
- 2+ years of experience administering Microsoft SQL Server databases.
- A Bachelors degree in Computer Science, Information Technology, or a related field.
- Strong understanding of relational databases and distributed database management.
- Proven experience in database instance planning, installation, configuration, and maintenance.
- Expertise in designing enterprise-level database architectures, including high availability and scalability solutions.
- Demonstrated experience in disaster recovery planning and execution in HA environments.
- High proficiency with physical database and schema design in 3rd normal form.
- Experience with automation and scripting languages for database administration tasks (Python, Ansible, Bash, etc.).
- Experience with database performance measurement and optimization.
- Ability to tune and optimize poorly performing queries.
- Hands-on experience with bulk data loading.
- Familiarity with database security best practices.
- Ability to collaborate with developers to address performance and data access requirements.
- Strong communication and collaboration skills to work effectively with cross-functional teams.
- Proven ability to stay current with new database technologies and proactively recommend improvements.
- Excellent time management skills, with the ability to handle multiple tasks, prioritize, and meet deadlines.
- Strong problem-solving skills related to database performance and application software.
- 12+ years of hands-on experience in relational database administration.
- 6+ years of experience administering DB2 databases.
- 6+ years of experience administering Microsoft SQL Server databases.
- A Masters degree in Computer Science, Information Technology, or a related field.
- Certification in DB2 administration or related technologies.
- Experience with RDBMS versioning software (e.g., Liquibase, Flyway).
- Familiarity with change data capture and replication technologies (e.g., IBM Infosphere Data Replication).
- Experience with JSON/document databases (e.g., Couchbase, MongoDB).
- Experience administering other RDBMS (e.g., Oracle, PostgreSQL, MariaDB).
- Familiarity with cloud-based database solutions.
- Ability to identify process improvements and implement tools for increased efficiency and productivity.