Senior Database Administrator

As a Senior Database Administrator at ManTech, your primary responsibilities will include designing and maintaining Oracle 19c databases, leading ETL development, conducting performance tuning, and optimizing database queries for peak performance. You'll also manage backups and recovery, ensure system reliability, and participate in server capacity planning.

To qualify for the Senior Database Administrator role at ManTech, you should have at least a High School Diploma and 7+ years of experience in the IT field. Significant experience with Oracle 19c, Oracle Exadata, and database design on Linux systems is essential. Additionally, expertise in performance optimization and knowledge of various database technologies will be beneficial.

Preferred qualifications for the Senior Database Administrator position at ManTech include experience with PostgreSQL architecture, knowledge of Oracle Cloud Technology, and Oracle certifications. Familiarity with multiple data-storage technologies and the ability to collaborate across teams also enhance your application.

Performance tuning is vital in the Senior Database Administrator role at ManTech as it ensures the databases operate efficiently, especially when handling terabytes to petabytes of data. By optimizing queries and adjusting system parameters, you'll enhance performance, improve user experience, and support our scalable database solutions.

At ManTech, the work environment for a Senior Database Administrator is collaborative and dynamic. You will work within a skilled DBA team in Chantilly, VA, utilizing the latest technologies to solve complex data challenges. Our culture values teamwork, professional growth, and innovation, making it an exciting place for tech-savvy professionals.

Essential steps to ensure database security include implementing user authentication and authorization, regularly updating security patches, utilizing Oracle Label Security, and securing data using encryption techniques. It's important to stay informed on potential vulnerabilities and to conduct regular audits for compliance.

When tuning large Oracle databases, I begin with monitoring execution plans and identifying slow-performing queries. I analyze indexes, refactor SQL statements, and utilize tools like AWR reports to pinpoint bottlenecks. Implementing partitioning and archiving strategies can further enhance the performance of large datasets.

I've utilized RMAN for backups, employing both full and incremental backups to ensure data integrity. I also implement Data Guard for disaster recovery, regularly testing restore processes to confirm that backups can be successfully recovered when needed.

Collaboration with other teams involves clear communication and a willingness to understand their needs. I prioritize hosting regular meetings to discuss database requirements and performance. Using collaborative project management tools helps to keep everyone informed and aligned on database enhancements and optimizations.

In my previous roles, I've scripted routine tasks using shell scripts and PL/SQL to automate monitoring, backups, and maintenance. This has significantly improved efficiency and reduced the potential for human-errors in managing large databases.

To optimize a poorly performing query, I typically analyze the execution plan first to identify inefficiencies. From there, I might add appropriate indexes, rework joins, eliminate unnecessary columns, or consider rewiring subqueries into more efficient structures to enhance performance.

I have extensive experience with OLTP systems focusing on transaction management and data integrity, as well as OLAP systems for analytical processing. Balancing the needs of both types of systems is crucial in ensuring that operational data is used effectively for strategic insights.

Ensuring data integrity involves constraints like primary keys and foreign keys, regular audits, and utilizing ACID properties during transactions. I also design databases with normalization in mind to reduce redundancy and maintain clean, accurate data across the system.

When faced with a database performance issue, I immediately consult monitoring tools to assess the situation. Analyzing resource usage and query performance helps diagnose issues, allowing me to implement immediate fixes while planning long-term optimizations based on my findings.

I am excited about the opportunity at ManTech due to its commitment to innovation and technology solutions. I admire the team-oriented approach and look forward to collaborating with talented professionals to tackle complex data management challenges while contributing to the company's success.