Oracle DBA

Oracle DBA
Essential Job Functions:-
• Evaluate patch releases from Oracle and patching requests from development, and communicating constraints, issues, and timelines for deployment.
• Change management including maintenance of multiple development, test, QA, and production environments. Responsible for deploying approved changes to production.
• Provide 24x7 rotational on-call support, including driving Root Cause Analysis (RCA), Preventative action follow-though, and participation in weekly operations reviews.
• Provide proactive database monitoring and issue resolution
• Perform database and PL/SQL optimization including performance tuning, query optimization and supportability.
• Participate and contribute to projects involving enterprise systems enhancements.
• Perform Implementation and ongoing support of high availability architecture (standby logical/physical Data Guard, RAC, hot standby databases, etc.)
• Work with development project teams to design and implement database solutions to meet business requirements.
• Participate in project design and Oracle database design decisions. Refine and troubleshoot the design.
• Create and maintain appropriate documentation about the database and the data architecture.
• Support of the nightly ETL processing
• Ensure regular proactive capacity planning and tending reviews of all oracle databases. Producing weekly, monthly management reports.
• Attend project kick-offs and design reviews as necessary to appropriately size new environments, recommend infrastructure solutions and deliver associated cost and resource effort estimates
• Develop and implement Database security polices and procedures, in line with corporate objectives
• Perform other duties as assigned

 

Position Requirements:-
• Must have over 6 years of Oracle DBA working experience on Oracle Database 10g, 11g and/or 12c.
• Must be knowledgeable and experienced working with multiple operating systems including Microsoft Windows and Linux.
• Experienced in Database backup using RMAN with RMAN Catalog.
• Must be experienced using Oracle 10g, 11g and/or 12c Data Guard.
• Must be experienced using OEM Grid Control, Emrep and OMS.  Experienced with tools such as Toad, Spotlight, or other Monitoring tools.
• Strong skills in PL/SQL and UNIX/Linux Shell Scripting
• Strong SQL and PL/SQL Design, Development, Tuning and debugging skills
• Experience with Oracle Security Administration
• Ability to maintain a positive attitude while working with high demands and short deadlines
• Ability to prioritize heavy workload with minimum supervision.
• Highly adaptable with ability to work in a fast paced demanding environment
• Must have excellent communications and interpersonal skills.
• Ability to work well with development and infrastructure teams in doing database design, changes and enhancement to new and existing applications.
• Support interfaces and back-end integration with applications.
• Strong Troubleshooting Skills.
• Strong organizational and analytical skills.
• Understanding of High Availability and Disaster Recovery requirements and solutions.

Preferred:-
• Oracle Education and Certifications (OCP) are a plus.
• Experience with Oracle Streams and/or database replication is a plus.
• Security and compliance experience including Encryption, Audit, Authentication, PCI, GLBA, SOX, etc.
• Experience in supporting Oracle RAC environments and ASM is preferred.
• Experience in data modeling and DM tools such as Oracle Data Modeler, Erwin, Toad, Visio, etc.
• Understanding of or experience supporting .NET application

 

Qualification:- BACHELOR OF COMPUTER SCIENCE