This position reports to AVP – IT Operations, along with the roles of IT Analyst – Operations, Senior and Lead Database administrators. The functions performed or supported by the Senior Database Administrator ensures the security, integrity, confidentiality, reliability, accessibility and availability of member-centric and operational-specific data and information.
DESIRED COMPETENCIES AND EXPERIENCE
An incumbent in this position must possess an advanced level of database administration expertise, as well as the skills/abilities to fulfill the accountabilities described in this document. A typical pathway to obtaining the requisite knowledge and skills is graduation from a four-year college or university with a degree in computer science, computer information systems or management information systems and a minimum of 7+ years of experience in database administration. Work assignments require flexibility to work independently, as well as in a team-based environment. Expertise in Oracle and Microsoft SQL Server database administration necessary. Proven track record of major database system implementations and support and an understanding of application development methodology required, as well as project management exposure. Strong organizational, interpersonal, communication skills and professional appearance essential.
Minimum application/system work experience requirements:
5 years of Oracle database maintenance and support
2 years of Microsoft SQL Server maintenance and support
2 years of supporting a Data Warehousing environment
Experience in Installing, Upgrading and Patching of Oracle 11g and 12c databases on Production Environment in RHEL 7/ Windows OS.
Very Good work Experience in Creating, maintaining, troubleshooting Oracle Data Guard in various architectures (Physical Standby, Snapshot Standby & Active Data Guard etc.)
Expertise in Oracle Database Performance Tuning including Wait Events, SQL Plan Management, SQL Tuning Advisor, SQL Baselines etc.
Experience in Database Backup and Recovery using both Physical and Logical methods.
Extensive experience in setting up RMAN backup and able to create, reuse and customize RMAN scripts.
Very Good experience in working with Oracle OMS 13c (Both server & Agent) for database Performance monitoring, alert notification and trend analysis.
Experience in Database User Configuration, Security, Auditing and Data Encryption (TDE).
Experience in working with Application teams to develop and debug/enhance PL/SQL, stored Procedures, Packages and Triggers.
Experience in writing UNIX shell scripts to Monitor Database and automate tasks.
Experience in Linux OS commands to perform OS server health checks.
Good working knowledge with My Oracle Support to resolve database outages and oracle problems.
Additional qualifications preferred:
OCP - Oracle Certified Professional
MCDBA – Microsoft Certified Database Administrator Certification
Microsoft Reporting Services Framework
Supporting Web Based Technologies
Advanced MS Excel skills
Financial/Banking industry experience