SQL Database Administrator
3B Staffing LLC, Richmond, VA, United States
SQL Database Administrator
Key Responsibilities:
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.
Minimum Qualifications:
6+ 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 Bachelor's 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.
Preferred Qualifications:
A Master's 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.
Key Responsibilities:
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.
Minimum Qualifications:
6+ 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 Bachelor's 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.
Preferred Qualifications:
A Master's 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.