Senior SQL Database Administrator

About the position

BAI, a defense contractor, is seeking a Senior Database Administrator with at least 14+ years of experience who will sustain and provide future solutions and resolutions for the established Electronic Warfare Data System (EWDS) database at Naval Base Point Mugu, CA. Opportunities for career advancement, excellent benefits and stability are some of the advantages of our well-established, employee-focused company.

Responsibilities

• Demonstrate a high level of knowledge and experience in database management systems, standards, requirements, guidelines, and quality assurance for database deliverables such as transactions and backups.
• Demonstrate experience with conceptual design and architecture of databases, capacity planning, external data interface specification, data loading plan, data maintenance plan, and security policy.
• Demonstrate an expert degree of experience in SQL, SQL Server Management Studio (SSMS), PostgreSQL, and pgAdmin.
• Monitor, analyze, configure, test, and report database conditions to ensure successful database development and maintenance.
• Develop new databases, as required, and update existing databases; heavy SQL and PostgreSQL use.
• Develop quality assurance checks and exercises to test readiness responses and communication channels.
• Respond to customers and users for assistance in database integration and development.
• Translate client's business requirements into a logical model that will accurately support and represent the client's entity relationship and flow of data.
• Develop appropriate database frameworks to convert logical models into physical models including the creation and maintenance of schemas containing tables, columns, views, functions, and stored procedures.
• Make recommendations to maximize operating efficiency, support storage requirements, vendor software updates, enforce data governance, and ensure recovery is maintained.
• Participate in quality assurance processes.

Requirements

• Minimum of 14 years of experience performing the duties described in the job description and responsibilities.
• Experience and/or service integration services with at least 4 years' experience on a program that provides infrastructure services including compute, storage database, transport, enterprise management and/or desktop services.
• Experience with database technologies including Postgres, SQL Server, MySQL.
• Excellent data evaluation skills and use of tools like MS Excel or Tableau.
• Ability to manage priorities across multiple projects and actively multi-task.
• Strong problem solving and troubleshooting skills.
• Strong communication and interpersonal skills.

Nice-to-haves

• Prior experience working with or within the Intelligence Community or military intelligence.
• Experience as a Data Scientist, Data Engineer, Data Analyst or Quality Analyst.
• Experience with or understanding of various programming/scripting languages such as C#, Java, and or Python.

Benefits

• Opportunities for career advancement.
• Excellent benefits.
• Stability in a well-established, employee-focused company.