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