Proven experience in Database Administration / Database Design & Development using Azure/SQL Server databases in an IaaS/PaaS environment. Proficient in data migration and conversion from on-premises Oracle to Microsoft Azure SQL Server.

Performs highly complex data management functions at an enterprise level; integrates, upgrades, and manages database environments; plans, organizes, tests and executes migration of databases from development to production environments.

Experience must include developing stored procedures/triggers/scripts/SQL and optimizing/tuning SQL in enterprise-class production and development/test environments.

Implementing and maintaining data security protocols;configuring database authorization & authentication using platform and database tools;configures object-level permissions;implements data masking;implements compliance controls for sensitive data/PII

Experience configuring and monitoring activity and performance for AzureSQL at the infrastructure, server, service, and database levels

Experience configuring and monitoring activity and performance– including QueryStore; resolving production and operational problems; monitoring utilization and managing available database resources; all the above in order to optimize and tune performance.

Configure storage resources; configure compute resources for scaling; analyzes data resource and server capacity and forecasts growth requirements; recommends server, hardware and software upgrades and enhancements to meet long-term needs.

Provides enterprise-level short and long-term planning advice on technical enterprise database and systems management and utilization issues.

Experience with T/SQL, SQL, DML, DDL and DCL – to debug and resolve issues.

Experience with RDBMS admin/console tools such as TOAD, SSMS and/or SQL Developer.

Experience documenting data migration processes, CI/CD process, ETL pipelines, day-to-day operations.

Configuring data integration and batch processing solutions in Azure Data Factory and/or SSIS; monitoring data ingestion processes and performance; review query plans and identify problem areas in execution plans.

Demonstrated experience leading and evaluating the implementation of project requests to ensure efficient use of server/database resources. Further, in terms of logical design so as not to create inefficiencies, and unreasonable demands on computing res

Demonstrated experience leading efficiency improvements and implementation of database administration policies and procedures.

Demonstrates experience in data and systems architect duties; experience in migrating data from spreadsheets and from Oracle through SQL Server Migration Assistant (SSMA) and other platforms to Azure PaaS using Azure Data Factory

Demonstrates and promotes the effective sharing and utilization of common data across applications and departments/business units.

Validate database build requirements, leverage automation tools to complete requirements.

Bachelors or advanced degree in computer science, computer information systems, management information systems, or a closely related field.

Agile methodology.