Dieses Stellenangebot ist nicht mehr verfügbar
Über
100% REMOTE from TEXAS
Job Description: • 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 Azures SQL at the infrastructure, server, service, and database levels • Experience configuring and monitoring activity and performance- including Query Store; 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; analyses 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.
Sprachkenntnisse
- English
Hinweis für Nutzer
Dieses Stellenangebot wurde von einem unserer Partner veröffentlicht. Sie können das Originalangebot einsehen hier.