Senior Database Administrator

About Beacon Systems, Inc

Beacon Systems, Inc, delivers Program Management, Science, Engineering, and Technology Solutions to Federal, Commercial, State, and Local Agencies. We are a subsidiary of Radiant Digital Solutions. Our Technology support to many DoD Agencies, NASA, Voice of America, FDA, and State Agencies such as State of FL, RI, MS, ND, VA, and WV extends our delivery of solutions worldwide.

Position: Senior Database Administrator

Location: Hybrid - Austin, TX

Duration: 12 Months

Job Description:

Senior Database Administrator (Database Administrator III) and will perform advanced database administration tasks for databases used by applications with complex data models, workflows, and reports. Assists the team in creating and maintaining logical and physical data models. The successful candidate will work with Full-stack Java applications on cloud platform (Azure/AWS) within an Agile (Scrum) environment. The role will involve migrating data from Oracle applications to SQL schemas and loading it into collections. Additionally, the candidate will optimize database performance during and after migration, identify and resolve performance bottlenecks, and implement monitoring solutions to track database health and performance metrics. The DBA works on activities including but not limited to database tuning, indexing, customization, transformation, data migrations/conversions, installations, troubleshooting, upgrades, patching, user management, security of data at rest and in motion, disaster recovery, clustering for high availability and load balancing, data backup, purging and archiving, implementation of database policies, data replication and backup to secondary sites like disaster recovery environments, procedures for the integrity, availability, and confidentiality of the sensitive and business-critical databases. The role will involve working closely with the team to create and maintain logical and physical data models, with a primary focus on Oracle and Azure Microsoft SQL. This role will require converting Oracle Stored Procedures and Functions to Azure SQL.

Required/Preferred skills

·        Database experience

·        Experience with Oracle, Microsoft SQL - (or similar)

·        Experience with Relational Database Administration - (SQL Server or Oracle, for example)

·        Experience in database design, analysis and performance tuning

·        Experience in database structures, data analysis, performance tuning

·        Experience designing enterprise applications and/or services

·        Experience creating technical and functional design documentation

·        Experience within software development Life Cycle using Agile methodology – (Scrum, for example)

·        Experience with multi-tier system/application development – (SOA, Microservices, 3-Tier applications, for example)

·        Experience with large volume databases, high availability, and disaster recovery infrastructure

·        Experience with Azure

·        Ability to Extract, transform, and load (ETL) data from various sources into Azure SQL

·        Experience in DevOps technology including CI/CD pipeline and build and deployment tools such as Git

·        Experience in Java/J2EE Enterprise Development

·        Azure certification is preferred

·       DBA Associate certifications are preferred