What are the responsibilities and job description for the Senior Database Administrator position at assystinc?
ASSYST is seeking a Senior Database Administrator (DBA) with 15 years of database administration experience to support database design, administration, performance tuning, optimization, and operational activities across multiple platforms. The ideal candidate will have strong expertise in DB2 for z/OS, Oracle, and Microsoft SQL Server, along with extensive experience in z/OS environments, database architecture, monitoring, recovery, and infrastructure support.
Roles & Responsibilities
- Perform daily database administration and operational support for DB2, Oracle, SQL Server, and GIS environments.
- Design, implement, maintain, and optimize database structures and schemas.
- Monitor and tune database performance and troubleshoot database-related issues.
- Support DB2 for z/OS upgrades, catalog maintenance, application integration, and point-in-time recovery.
- Develop and maintain database administration procedures and technical documentation.
- Perform SQL code reviews and support database optimization.
- Support infrastructure implementation, change management, verification testing, and disaster recovery activities.
- Utilize database and z/OS monitoring tools to identify and resolve performance issues.
- Collaborate with technical teams on data architecture and application integration.
- Provide training and mentoring to other technical staff.
Required Skills
- 15 years of combined database administration experience.
- Strong expertise in:
- DB2 for z/OS
- Oracle 10g
- Microsoft SQL Server 2008 R2/2012
- Advanced knowledge of DB2 for z/OS administration, performance management, upgrades, catalog maintenance, and recovery.
- Strong knowledge of JCL, z/OS, ISPF, CICS, RACF, COBOL, and ASG Scheduler.
- Experience with DB2 and z/OS monitoring tools.
- Experience with SSMS, SSRS, SSIS, Windows Server, and Azure.
- Knowledge of CA GEN, IBI z/OS, AFOPER, IOF, z/OS EXITs, and BJS.
- Knowledge of disaster recovery and infrastructure change management.
- Strong SQL, troubleshooting, documentation, communication, and collaboration skills.
- Experience with integrated database/application environments is a plus.
ASSYST is an Equal Opportunity Employer. Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, disability, military status, national origin or any other characteristic protected under federal, state, or applicable local law.