Senior Database Administrator

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.

• Evaluate, design, and maintain multiple database environments; identify data sources, construct data decomposition diagrams, provide data flow diagrams and document the process; write codes for database access, modifications and constructions including stored procedures, database server configuration, operating system version and patch level, database version and patch level and database name/purpose/size/owner.
• Architect and administer database systems technical design, performance monitoring and tuning, backup and recovery, data and file distribution, reporting, database upgrades, integrations, migrations and conversions.
• Develop and maintain procedures and scripts for recreating the database environment and databases for disaster recovery purposes and business continuity strategy.
• Implement data models and database designs, data access and table maintenance codes; develop and maintain database administration procedures and operations; cross train on, and provide operational support of, procedures.
• Design, implement, and support data warehousing - implement business rules via stored procedures, middleware or other technologies; define user interfaces and functional specifications; responsible for verifying accuracy of data, and the maintenance and support of the data warehouse.
• Responsible for verifying accuracy of data, and the maintenance and support of the data warehouse.
• Monitor system details within the data warehouse, including stored procedures and execution time, and implement efficiency improvements.
• Troubleshoot and resolve database performance issues, database capacity issues, replication and other distributed data issues.
• Coordinate activities and maintain extensive communication with appropriate IT staff, user system administrators, department managers, UNFCU staff, project teams and third party vendors.
• Develop, implement, and maintain change control and testing processes for modifications to databases.
• Participate in assigned roles in project teams; serve as Database Systems Technical Liaison. Project-specific and other related activities may warrant some level of supervision and/or management of staff/resources.
• Perform regular file system maintenance activities such as purging, archiving, FTP and file encryption/decryption in Windows/UNIX/Linux environments.
• Recommend continuous database performance and process improvement ideas to management and develop solutions to optimize the operational process.
• Provide periodic technology metrics showing the improvement made in various database areas.
• Follow UNFCU IT Service Management processes, policies and procedures.
• Train other IT staff on necessary software.

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