**Job Title:** Data/Database Administrator

**Experience and Skill Set Requirements:**

**Must Haves:**
- Expert data/database administration experience (e.g., Microsoft Azure SQL Database, Synapse Database, Oracle, IMS, DB2).
- Extensive expertise in Microsoft Azure technologies including Azure Pipeline, DACPAC, Storage Account, Disk, File Share, Azure Key Vault, Azure Portal, Virtual Machine, Azure DevOps, Data Lake, Data Lakehouse, and Azure Monitoring Tools.
- Experience with Cloud data platforms, data management, and data exchange tools and technologies.
- Knowledge of Azure SQL, Oracle, IMS/DB2 data replication.

**Skill Set Requirements:**
- Expert experience with Microsoft Azure technologies as listed above.
- Proficiency in Data Pipeline and workflow development, orchestration, deployment, and automation.
- Strong understanding and application of DataOps principles, best practices, Agile project development and deployment.
- Experience with Continuous Integration/Continuous Deployment (CI/CD) and Data provisioning automation.
- Knowledge in digital product development, data analysis, data exchange, data provisioning, and data security.
- Familiarity with structured, semi-structured, and unstructured data collection, ingestion, provisioning, and exchange.
- Competence in DataOps performance monitoring and tuning.

**Database Management:**
- Expert data/database administration experience (e.g., Microsoft Azure SQL Database, Synapse Database, Oracle, IMS, DB2).
- Extensive experience with SQL Server Stored Procedure, Oracle PL/SQL, PL/1 development, and performance tuning.

**Data Replication Pipelines:**
- Experience with Azure SQL, Oracle, IMS/DB2 data replication.

**Deliverables:**
- Participate in the review of project, work request, and maintenance release artifacts, including Use Cases and System Requirement Specifications.
- Deliver detailed system design documents and supporting documentation conforming to standards.
- Design, develop, and optimize data/database CI/CD pipelines.
- Create logical and physical data models using Sybase Power Designer.
- Prepare database changes in DACPAC and develop Azure CI/CD release pipelines for deployment.
- Promote database changes through Development, Integration Testing, QA, UAT, and Production environments.
- Provision data in cloud environments based on requirements.
- Design, develop data loading, conversion, and migration programs.
- Implement data conversion of very large datasets in OLAP and OLTP environments to Cloud Software-as-a-Service (SaaS), Platform-as-a-Service (PaaS), and Infrastructure-as-a-Service (IaaS) environments.
- Design and implement fact/dimension models, data mapping, data warehouses, data lakes, and data lake houses.
- Plan, configure, maintain, administer, and tune performance of Oracle and Microsoft Azure SQL databases.
- Support cloud-based heterogeneous data replication solutions.
- Develop complex Oracle PL/SQL programs and SQL Server stored procedures.
- Optimize performance of PL/SQL programs and SQL Server stored procedures.
- Monitor and analyze incidents, providing timely resolutions.
- Perform reference data administration as required.
- Build and test database backup/recovery scripts and automation scripts.
- Conduct database administration, including patching/upgrade, monitoring, performance tuning, and capacity planning.
- Document and resolve any database issues.
- Provide effective knowledge transfer to staff at all stages of the assignment.

**Apply Now!**