Impress employers and recruiters.
Choose from hundreds of resume examples.

Impress employers and recruiters.
Choose from hundreds of resume examples.

Target Resume Now

About the Role

Allied Consultants, Inc is seeking an experienced Senior Database Administrator to play a key role within a high-impact technical services team. The role involves advanced database administration tasks for applications with complex data models, workflows, and reports, assisting in the creation and maintenance of logical and physical data models.

Responsibilities

• Perform advanced database administration tasks for databases used by applications with complex data models, workflows, and reports.
• Assist the team in creating and maintaining logical and physical data models.
• Work with Full-stack Java applications on client’s cloud platform (Azure/AWS) within an Agile (Scrum) environment.
• Migrate data from Oracle applications to SQL schemas and load it into collections.
• Optimize database performance during and after migration.
• Identify and resolve performance bottlenecks.
• Implement monitoring solutions to track database health and performance metrics.
• Perform 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.
• Ensure procedures for the integrity, availability, and confidentiality of sensitive and business-critical databases.
• Convert Oracle Stored Procedures and Functions to Azure SQL.
• Enter codes to create production databases.
• Select and enter codes of utility programs to monitor database performance.
• Direct programmers and analysts to make changes to database management systems.
• Review and correct programs.
• Answer user questions.
• Confer with coworkers to determine the impact of database changes on other systems and staff costs.
• Modify database programs to increase processing performance (performance tuning).
• Provide assistance in the planning, development, maintenance, and monitoring of integrated database systems.
• Ensure conceptual and design phases of new applications are consistent with structural parameters within the database environment.
• Evaluate users' requests for new data elements and systems, incorporate them into the existing shared data environment, and provide technical assistance.
• Coordinate the use of data to ensure data integrity and control redundancy.
• Load databases and reorganize as needed.
• Perform data modeling and prototyping.
• Perform logical and physical data modeling, design relational database models, and create physical data models from logical data models.
• Perform security recovery procedures.
• Determine and implement database search strategies and storage requirements.
• Maintain data dictionary ensuring uniformity of definitions and set standards for its use.
• Monitor database performance and recommend efficiency improvements.
• Create test database environments for applications sections.
• Execute procedures necessary to save, retrieve, and recover databases from hardware and software failures.
• Assist with determining, implementing, and enhancing standards on database security.
• Assist with monitoring agency disaster recovery procedures and systems.
• Assist with the installation of database software.
• Assist with analyzing, designing, and implementing databases.
• Assist in benchmarking and threshold testing of databases.
• Assist in establishing and controlling necessary database security.
• Assist in the selection of database management software.
• Ensure that user interfaces for database administration and data input/output are compliant with accessibility standards.
• Provide support to users in obtaining data/information when EIR Accessibility issues arise.

Requirements

• Candidates selected for interviews will be subject to a criminal background check and may be required to pass a drug screening.
• All offers of employment are contingent upon successful completion of these checks.
• Candidates for this position will be subject to a pre-employment security review to determine employment eligibility.
• Candidates that do not meet or exceed the minimum stated requirements (skills/experience) will be displayed to customers but may not be chosen for this opportunity.

Skills

• Oracle
• Microsoft SQL
• Relational Database Administration
• SQL Server
• Database design
• Database analysis
• Performance tuning
• Database structures
• Data analysis
• Enterprise application design
• Service design
• Technical design documentation
• Functional design documentation
• Agile methodology
• Scrum
• Multi-tier system development
• Application development
• SOA
• Microservices
• 3-Tier applications
• Large volume databases
• High availability
• Disaster recovery infrastructure
• Azure
• Extract, transform, and load (ETL) data
• DevOps technology
• CI/CD pipeline
• Build and deployment tools
• Git
• Java/J2EE Enterprise Development
• EIR Accessibility standards
• Assistive technologies

Location

• Austin

Work Type

• Full-time

Experience Level

• Senior
• 10 years of experience
• 8 years of experience
• 6 years of experience
• 3 years of experience
• 1 year of experience

Education Level

• Azure certification
• DBA Associate certifications

Benefits

• Medical insurance (with employer cost sharing)
• Life insurance
• A 401(K) plan with company match
• Flexible spending through a cafeteria plan

About the Company

• Allied Consultants, Inc is a proudly Austin based firm with over 34 years of experience delivering top-tier technical and business professionals within Texas State Agencies.

Equal Opportunity

• Allied Consultants is a proud to be an Equal Opportunity Employer.
• We celebrate diversity and are committed to creating an inclusive environment for all employees.