Quick Overview
Seniority
Mid Senior
Work mode
Hybrid
Location
Albany, NY, United States
Posted
16 hours ago
PL/SQLSQLScrumAzureSQL ServerAgile
Job Description
- 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.
Similar jobs
- GO
System Administrator
NewGovCIO
Pensacola, FL🇺🇸On-site16 hours agoTechnology - BA
Systems Engineer
NewBOOZ, ALLEN & HAMILTON, INC.
Fayetteville, NC🇺🇸$86.8k - $198k/yrHybrid16 hours agoActive DirectoryVMwareLinuxTechnology - LE
Linux Server Systems Administrator
NewLeidos
Silver Spring, MD🇺🇸$92.3k - $166.8k/yrOn-siteYesterdayOracleShellAWS+9Technology - LE
Linux Server Systems Administrator
NewLeidos
Rockville, MD🇺🇸$92.3k - $166.8k/yrOn-siteYesterdayOracleShellAWS+9Technology - LE
Linux Server Systems Administrator
NewLeidos
Gaithersburg, MD🇺🇸$92.3k - $166.8k/yrOn-siteYesterdayOracleShellAWS+9Technology - LE
Linux Server Systems Administrator
NewLeidos
Glen Echo, MD🇺🇸$92.3k - $166.8k/yrOn-siteYesterdayOracleShellAWS+9Technology - LE
Linux Server Systems Administrator
NewLeidos
Chevy Chase, MD🇺🇸$92.3k - $166.8k/yrOn-siteYesterdayOracleShellAWS+9Technology - LE
Linux Server Systems Administrator
NewLeidos
Takoma Park, MD🇺🇸$92.3k - $166.8k/yrOn-siteYesterdayOracleShellAWS+9Technology - LE
Linux Server Systems Administrator
NewLeidos
Bethesda, MD🇺🇸$92.3k - $166.8k/yrOn-siteYesterdayOracleShellAWS+9Technology - LE
Linux Server Systems Administrator
NewLeidos
Washington, DC🇺🇸$92.3k - $166.8k/yrOn-siteYesterdayOracleShellAWS+9Technology - LE
Linux Server Systems Administrator
NewLeidos
Hyattsville, MD🇺🇸$92.3k - $166.8k/yrOn-siteYesterdayOracleShellAWS+9Technology - LE
Linux Server Systems Administrator
NewLeidos
Arlington, VA🇺🇸$92.3k - $166.8k/yrOn-siteYesterdayOracleShellAWS+9Technology