What are the responsibilities and job description for the Database Admin position at Bits & Bytes Technology Solutions?
- Position Job Title: Database Administrator (Expert Level)
- Request ID / Position ID: HBITS-08-15049
- Work Location: AESB, 80 S. Swan Street, 7th Fl, Albany, NY, 12255
- Telecommuting: Allowed (50% / hybrid schedule)
- Interview Format: Webcasting (Candidate required to be on camera)
Mandatory & Requested Qualifications
Mandatory Qualifications (84 Months Experience Required):
- Experience designing and developing logical and physical data models and creating DDL scripts for tables, views, indexes, triggers, and stored procedures.
- Experience designing and developing Data Conversion Strategy Plans, Data Mapping Documents, and Gap Analysis documentation.
- Experience writing complex DML SQL against enterprise Microsoft SQL Server and IBM DB2 databases.
- Experience working with SQL Server Management Studio (SSMS), SSMS Job Scheduler, SSIS, SSRS, Export/Import tools, ER/Studio Data Architect, QMF for Workstation, Redgate SQL Compare, and TSO.
- Experience using SQL and PL/SQL programming languages.
- Experience performance tuning complex SQL against enterprise Microsoft SQL Server and IBM DB2 databases.
Requested Qualifications:
- Specialized Data Modeling Experience: 12 months of experience using ER/Studio Data Architect to support enterprise data architecture initiatives (logical/physical modeling, metadata management, database design, DDL generation).
- Hybrid Database Environment Experience: 24 months of experience designing enterprise data models and writing complex SQL for IBM DB2 z/OS and Microsoft SQL Server environments using ER/Studio, QMF for Workstation, TSO, SSMS, and Redgate SQL Compare.
- Professional Database Certification: Must possess at least one of the following:
- Microsoft Certified: Azure Database Administrator Associate (DP-300)
- Microsoft Certified: Azure Data Engineer Associate (DP-203)
- IBM Certified Database Administrator - DB2
- IBM Certified Application Developer - DB2
- Additional Experience (At least 12 months):
- Leading enterprise data architecture and database modernization initiatives.
- Preparing technical documentation for audits, compliance reviews, and regulatory reporting.
- Participating in Agile and Scrum-based project environments.
Salary : $60 - $75