Job Title : Oracle Golden Gate Database Administrator
Location : Remote
200 hours project
Job Description :
We Are looking for an experienced Oracle Golden Gate Database Administrator to be a part of the Database Support Team supporting the operations and maintenance of a large scale and world-wide Enterprise IT environment covering application hosting and support, enterprise services, and infrastructure services in the Washington D.C. metro area. 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.
- Self-motivated DBA professional provides coverage of the 2nd shift Oracle GoldenGate replication support as well as core Oracle RDBMS DBA support in a 24x7 production environment.
- 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 issue.
- Applies advanced methods, theories, and research techniques in the investigation and solution of the complex system requirements and problems.