OVERVIEW:
Implements and optimizes the computerized database systems that support the Company’s or client’s ability to function on a daily basis. Implements and maintains smooth operation and physical design of databases. Conducts performance tuning of indexes and databases in general. Reviews database design and integration of systems, provides backup recovery, and makes recommendations regarding enhancements and/or improvements. Maintains security and integrity controls. Formulates policies, procedures, and standards relating to database management, and monitors transaction activity and utilization. May develop stored procedures and/or triggers. Administers a variety of database systems, such as Oracle RDBMS, and other Database Management Systems (DBMS) like Microsoft SQL Server. Develops and enforces database administration and user standards and procedures; audits, modifies, and amends data in systems using SQL and PL/SQL commands. Oversees the scheduling of database projects, database and transaction log backups, notifications, and database replication between multiple Oracle RDBMS Servers and remote sites. Assists Database Designers/Information System Analysts in the development and creation of SQL and Web-based databases and database systems. Reviews technical designs, reports, documentation, and other materials produced by staff; creates and maintains high-level reporting systems using products such as Oracle BI publisher; researches and implements new databases and online technology.
GENERAL DUTIES:
- Hands-on participation and facilitation of full life cycle implementation of Oracle 19c RDBMS and 19c Oracle GoldenGate for production environments.
- Experience in upgrading the Oracle RDBMS system from 11g to 19c as well as the Transparent Data Encryption.
- Provide solid DBA skills on Oracle RAC and Data Guard installation, configuration, and troubleshooting production issues.
- Applies advanced methods, theories, and research techniques in the investigation and solution of the complex system requirements and problems
- Please note that this position has 3rd
REQUIRED QUALIFICATIONS:
- Requires 5 to 7 years with BS/BA or 3 to 5 years with MS/MA or 0 to 2 years with Ph.D. or 11 years of experience with no degree. Prefer Bachelor’s degree in systems engineering, computer science, management information systems, or related field
- Prior experience as an Oracle DBA
- Minimum 5 years of strong Oracle 11g or 12c DBA experience with specific knowledge of RAC, ASM, GoldenGate, Data Guard, RMAN, Patching, AND/OR Security
- Specific knowledge of writing custom monitoring reports for 12c OEM
- Experience working with Oracle Cloud Computing (private or public) is a plus
- Strong communication skills to communicate systems proposals to management and customers and provide systems diagnoses and resolution for current systems
- Strong organization skills to prioritize work, balance, and lead complex projects
- Good leadership skills to guide and mentor the work of less experienced personnel
- Previous experience on Oracle Engineered System like Exadata and Sun Super Cluster are welcomed
- Experience leading a group of DBAs is a plus
- Oracle Certified Professional certification
CLEARANCE:
- Secret minimum with the ability to obtain Top Secret