Senior Associate, Database Administration

A prestigious financial firm is on the search for a Senior Associate, Database Administration. This will be DB2 administration in a z/OS environment. This position will also need to have experience with DB2 LUW preferably on top pf Solaris. They will need experience with SQL coding and experience with Embarcadero/similar tools (E/R Studio, DBArtisan, and Schema Manager).

Responsibilities

• Assists with the design, implementation, and maintaining databases
• Provides consultation support in database analysis, modelling, coding and production problem resolution
• Maintains metadata repositories
• Provides support in database access methods, device allocations and organization
• Develops maintenance, backup and recovery procedures and documentation
• Manage database performance and disk usage
• Participates in Disaster Recovery drills
• Provides Primary On-Call Support for production problems
• Recommends and assists with new DBMS and operational standards.
• Participates in testing and in evaluations of new software and software release upgrades

Qualifications

• 1+ years' experience developing and maintaining complex applications that make extensive use of a supported database technology or 2+ years' experience as an associate DBA
• Well versed in all phases of Systems Analysis and Design
• Experienced in two or more programming languages and two or more Scripting languages
• Practiced at Entity/Relationship or Object modelling and translation to physical database designs
• Proficient in DML, DDL, and database utilities for at least two DBMS technologies
• Proficient in all access methods of a DBMS as well as the underlying operating system access methods
• Knowledge of hardware and operating system capabilities within one environment
• Understanding of all software subsystems (DBMS, TP Managers, etc.) for one environment
• 1+ years' experience with DB2 in a z/OS environment
• 1+ years' experience with DB2 LUW, preferably on Solaris
• 1+ years' experience with SQL Server
• Experience with Embarcadero/similar tools (E/R Studio, DBArtisan, and Schema Manager)
• Experience with BMC tools for DB2 (Change/Catalog Manager, MainView, Log Master)
• Proficient with coding and review of SQL, stored procedures, and triggers
• Bachelor's Degree (or equivalent) in Computer Science, Engineering, Mathematics