Database Administrator - AXS Group LLC
Dallas, TX 75252
About the Job
Summary
Assists with the design, implementation, maintenance of databases for multiple complex, enterprise-level development programs. Duties include assisting the Database Administrator with the development and design of database strategies; monitoring and improving database performance and capacity; data recovery; planning for future expansion and conversion, coordination and implementation of security measures to safeguard organizational databases; implementation and release of database changes as submitted by the development team, and general administrator support.
Responsibilities
- Monitors databases to optimize database performance, resource use, and physical implementations of databases; addresses a variety of database integration issues including migration between disparate databases, integration, maintenance/conversion, capacity planning issues, and new applications.
- Develop, implement and maintain change control and testing processes for modifications to database.
- Monitors and maintains database security and database software, in cooperation with data security administrators.
- Maintains availability and integrity of databases through multiple access schemes; facilitates sharing of common data by overseeing proper key and index management and data dictionary maintenance.
- Monitors and manages database backups, logs, and journals; installs, maintains, and upgrades database software; restores and/or recovers data as required.
- Provides advice to applications programmers in the effective use of database languages; advises on troubleshooting, exception processing needs, and other data management issues.
- Creates, procures and maintains various database related documents such as manuals and programmers’ handbooks.
- Provide on-call support.
- Performs miscellaneous job-related duties as assigned.
Requirements
- Bachelor's degree and 6+ years of related experience, or equivalent experience in lieu of degree
- 4+ years of experience managing multi node Oracle RAC 11Gr2, 12C;
- 2+ years of in-depth experience with performance tuning, explain plan execution processes.
- 2+ years of experience in relevant database design, development, implementation, test and documentation
- 2+ years experience in a dev-ops environment
- SqlServer 2012 Always On experience highly desirable
- Experience with Redshift is highly desirable
- Working knowledge on writing Procedural language (PL/SQL) knowledge and experience preferred
- Ability to provide technical guidance and leadership to professional personnel in area of expertise
Source : AXS Group LLC