Database Administrator Expert

• Build and maintain enterprise data architecture based on business and technical requirements.
• Design and develop logical and physical data models using ER/Studio Data Architect.
• Create and maintain DDL scripts for tables, views, indexes, constraints, triggers, and stored procedures.
• Write, optimize, and maintain complex SQL and DML scripts against Microsoft SQL Server and IBM DB2 databases.
• Support data conversion activities including data mapping, transformation, reconciliation, validation, and migration.
• Collaborate with project managers, business analysts, application developers, solution architects, and QA teams to ensure database solutions meet project requirements.
• Analyze and tune database performance through query optimization, indexing strategies, and execution plan analysis.
• Work directly with client representatives to understand business rules, conduct gap analysis, and support data-related initiatives.
• Provide technical guidance development support for QMF for Workstation reporting and query solutions.
• Utilize SQL Server Management Studio (SSMS), SSIS, SSRS, Redgate SQL Compare, TSO, and related tools to support database administration and development activities.
• Develop and maintain technical documentation, including data models, data dictionaries, source-to-target mapping documents, process flows, and database standards.
• Support database deployment, version control, data quality initiatives, and change management activities.
• Mentor junior team members and provide guidance on database design and development best practices

Required Qualifications:

• 84 months of experience designing and developing logical and physical data models and creating DDL scripts for tables, views, indexes, triggers, and
• stored procedures.
• 84 months of experience designing and developing Data Conversion Strategy Plans, Data Mapping Documents, and Gap Analysis documentation.
• 84 months of experience writing complex DML SQL against enterprise Microsoft SQL Server and IBM DB2 databases.
• 84 months of 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.
• 84 months of experience using SQL and PL/SQL programming languages.
• 60 months of experience performance tuning complex SQL against enterprise Microsoft SQL Server and IBM DB2 databases
• Specialized Data Modeling Experience: 12 months of experience using ER/Studio Data Architect to support enterprise data architecture initiatives, including logical and physical data modeling, metadata management, database design, and 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 utilizing ER/Studio Data Architect, QMF for Workstation, TSO, SQL Server Management Studio (SSMS), and Redgate SQL Compare.
• Candidate must possess at least one of the following certifications:

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