Database Administrator

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