Database Administrator II
· United States
- Hybrid
- Contract
- $90,000 / year
- United States
Tailored resume — keyword-matched to this role.
Hiring manager — we find who's hiring.
Intro email — drafted to reach them directly.
Job highlights
- Administer and maintain database systems.
- Design and implement database structures.
- Ensure data integrity and security.
- Optimize database performance.
- Support data warehouse and data mart initiatives.
About the role
Database Administrator II
We are seeking a skilled Database Administrator II with at least 5 years of experience to join our team. In this role, you will be responsible for the installation, configuration, upgrading, and maintenance of database management systems, ensuring data integrity and optimal performance.
Key Responsibilities
- Install, configure, upgrade, and maintain database management systems.
- Support database migrations and validate data integrity following upgrades.
- Design, analyze, modify, and maintain database structures and architectures.
- Develop and implement backup, recovery, and disaster recovery procedures.
- Monitor database performance and implement tuning strategies to improve efficiency.
- Establish and manage database security controls, user roles, and access permissions.
- Create and maintain database documentation, standards, and data dictionaries.
- Perform logical and physical data modeling, including relational database design.
- Support data warehouse environments and data mart implementations.
- Collaborate with application developers and analysts to integrate database solutions.
- Evaluate and recommend database software, tools, and technologies.
- Assist in establishing database governance, standards, and best practices.
- Troubleshoot database issues and provide technical support to end users.
- Ensure compliance with accessibility standards for database administration interfaces and reporting systems.
- Support benchmarking, threshold testing, and capacity planning initiatives.
Required Qualifications
- Minimum 5 years of experience in database administration and database management systems.
- Experience developing, implementing, and maintaining enterprise data warehouses and data marts.
- Experience creating and maintaining data dictionaries.
- Experience utilizing database access tools for application delivery.
- Experience with database performance monitoring and optimization.
- Experience with data warehouse implementation lifecycles, including: Business requirements gathering, Data modeling, Physical database design, Data sourcing and transformation, Data loading and integration, SQL development and optimization.
Key skills/competency
- Database Administration
- Database Management Systems
- Data Warehousing
- Data Modeling
- SQL
- Performance Tuning
- Database Security
- Backup and Recovery
- Disaster Recovery
- Data Dictionaries
Skills & topics
- Database Administrator
- Database Management
- SQL
- Data Warehousing
- Data Modeling
- Performance Tuning
- Database Security
- Backup and Recovery
- Data Marts
- Database Architecture
How to get hired
- Tailor your resume: Highlight your 5+ years of database administration experience, focusing on data warehousing, modeling, and performance optimization.
- Showcase data warehouse expertise: Emphasize your experience with full data warehouse lifecycles, including requirements gathering, design, and implementation.
- Quantify achievements: Use numbers to demonstrate your impact in performance tuning, security implementation, or successful migrations.
- Prepare for technical questions: Be ready to discuss database architecture, SQL optimization, and disaster recovery strategies.
- Demonstrate problem-solving skills: Prepare examples of how you’ve troubleshot and resolved complex database issues.
Technical preparation
Master SQL for complex queries and optimization.,Practice data modeling techniques.,Review backup and disaster recovery strategies.,Familiarize with performance tuning tools.
Behavioral questions
Describe a complex database issue you solved.,How do you handle critical data security threats?,Explain your process for performance optimization.,How do you collaborate with application developers?
Frequently asked questions
- What are the key responsibilities for a Database Administrator II?
- The key responsibilities for a Database Administrator II include installing, configuring, and maintaining database systems, designing database structures, developing backup and recovery procedures, monitoring performance, managing security, and supporting data warehouse environments. You will also collaborate with developers and troubleshoot issues.
- What qualifications are required for the Database Administrator II role?
- We require a minimum of 5 years of experience in database administration. Essential qualifications include experience with enterprise data warehouses and data marts, creating data dictionaries, using database access tools, performance monitoring and optimization, and familiarity with data warehouse implementation lifecycles.
- What kind of experience is needed for data warehouse implementation lifecycles?
- For data warehouse implementation lifecycles, we are looking for experience in business requirements gathering, data modeling, physical database design, data sourcing and transformation, data loading and integration, and SQL development and optimization.
- How important is database security for this role?
- Database security is very important. The Database Administrator II is responsible for establishing and managing database security controls, user roles, and access permissions to protect sensitive data.
- Will I be involved in performance tuning and optimization?
- Yes, performance monitoring and optimization are key responsibilities. You will monitor database performance, implement tuning strategies to improve efficiency, and support capacity planning initiatives.
- What is the expected work arrangement for this Database Administrator II position?
- While the job description does not explicitly state the work arrangement, typical Database Administrator roles often involve a hybrid or on-site model due to the critical nature of system maintenance and security. Further details would be discussed during the interview process.
- What technical skills are most crucial for a Database Administrator II?
- Crucial technical skills include deep knowledge of database management systems, SQL development and optimization, data modeling (logical and physical), data warehousing concepts, performance tuning, backup and recovery strategies, and database security.