Job Title: Senior Database Administrator
Job Location- Austin Texas- Hybrid
Interview Mode- In person/MS Teams
Job Summary
We are seeking an experienced Senior Database Administrator to support enterprise-level database environments involving complex data models, applications, workflows, and reporting systems. The ideal candidate will have extensive experience in database administration, architecture, performance tuning, data migration, security, disaster recovery, and high-availability solutions.
The successful candidate will work closely with application development teams, architects, and business stakeholders to design, implement, maintain, and optimize database solutions. This role requires strong expertise with Oracle and Microsoft SQL Server/Azure SQL, database performance optimization, data modeling, ETL processes, and Agile software development environments.
Key Responsibilities
- Perform advanced database administration activities supporting enterprise applications and mission-critical systems.
- Design, develop, maintain, and monitor integrated database environments.
- Create, modify, and optimize database structures, schemas, tables, indexes, stored procedures, functions, and queries.
- Perform database performance tuning, including query optimization, indexing strategies, resource utilization analysis, and bottleneck resolution.
- Monitor database health, performance metrics, availability, and capacity utilization; recommend improvements as needed.
- Support database migrations, conversions, transformations, and modernization initiatives.
- Perform Oracle database migration activities and conversion of Oracle stored procedures/functions to Azure SQL environments.
- Develop and maintain logical and physical data models, relational database designs, and database prototypes.
- Support enterprise application development teams by providing database design guidance and technical expertise.
- Analyze user requirements for new data elements, database enhancements, and system integrations.
- Ensure database changes maintain data integrity, security, performance, and compliance with established standards.
- Manage database security, including user access, permissions, encryption, and protection of data at rest and in transit.
- Implement and support database backup, recovery, disaster recovery, replication, and high-availability solutions.
- Perform database installation, configuration, upgrades, patching, and troubleshooting.
- Create and maintain database documentation, technical specifications, data dictionaries, and operational procedures.
- Establish and maintain database standards, policies, and best practices.
- Support ETL processes to extract, transform, and load data from multiple sources into enterprise database platforms.
- Create and maintain test database environments, including required libraries, procedures, and configurations.
- Assist with capacity planning, benchmarking, threshold testing, and database optimization initiatives.
- Collaborate with Agile development teams working with Java/J2EE, cloud-based applications, and modern application architectures.
- Provide technical support and troubleshooting assistance to application teams and end users.
- Ensure database administration tools, reporting interfaces, and user-facing data applications align with accessibility standards.
Required Qualifications
- Bachelor's degree in Computer Science, Information Systems, Engineering, or related field, or equivalent professional experience.
- 10+ years of experience in database administration.
- 8+ years of experience with Oracle, Microsoft SQL Server, or similar enterprise database platforms.
- Strong experience with relational database administration, architecture, and maintenance.
- Extensive experience with database design, analysis, optimization, and performance tuning.
- Strong understanding of database structures, data modeling concepts, and database technologies.
- Experience designing and supporting enterprise applications and database-driven services.
- Experience creating technical and functional design documentation.
- Experience working throughout the Software Development Life Cycle (SDLC) using Agile methodologies such as Scrum.
- Experience supporting multi-tier application architectures, including SOA, Microservices, and 3-tier applications.
- Strong knowledge of database security, backup/recovery strategies, and disaster recovery processes.
- Experience troubleshooting complex database issues and implementing performance improvements.
Preferred Qualifications
- Experience supporting large-volume databases with high availability and disaster recovery infrastructure.
- Experience with Microsoft Azure cloud services and Azure SQL Database.
- Experience performing ETL activities and migrating data from multiple sources into Azure SQL.
- Experience with DevOps practices, including CI/CD pipelines, Git, and automated deployment processes.
- Experience supporting Java/J2EE enterprise applications.
- Experience with cloud database modernization and migration initiatives.
- Azure database or cloud certifications preferred.
- Database Administrator certifications preferred.
Technical Skills
- Oracle Database Administration
- Microsoft SQL Server / Azure SQL
- Relational Database Management Systems (RDBMS)
- Database Design & Data Modeling
- Logical and Physical Data Models
- SQL Development & Optimization
- Stored Procedures & Functions
- Performance Tuning & Query Optimization
- Indexing Strategies
- Database Migration & Conversion
- ETL/Data Integration
- Backup & Recovery
- Disaster Recovery (DR)
- High Availability & Clustering
- Data Replication
- Database Security
- Cloud Database Platforms (Azure preferred)
- Agile/Scrum Methodologies
- CI/CD Pipelines & Git
- Java/J2EE Application Support