Hi Hope you are doing fine
Please let me know if you have any suitable candidate for the below role
Title: Sr. SQL DBA (with Azure Synapse exp.)
Position Type: Contract
Location: United States
Description:
Azure Synapse Database Administrator
Boca Raton, Florida
Client Domain : e-comm
Visa : USC GC GCEAD H4 L2 OPT
Hybrid Role
General Characteristics
Manages and maintains all production and non-production databases. Responsible for standards and design of physical data storage, maintenance, access and security administration. Performs backup and recovery on Database Management Systems, configures database parameters, and prototype designs against logical data models, defines data repository requirements, data dictionaries and warehousing requirements. This position optimizes database access and allocates/re-allocates database resources for optimum configuration, database performance and cost.
Dimensions Education:
Bachelor's Degree in Computer Science, Information Systems, or other related field. Or equivalent work experience.
Experience:
• 5 + years MS SQL Server database administration experience
• Prior experience of configuring large-scale deployment of SQL Server in Azure, Managed Instance/Azure SQL, in a 24X7 production support, development or test environments
• Experience with the provisioning/administration/operations of Azure Synapse Analytics/Dedicated SQL Pools
• Experience with Performance Analysis, query optimization & troubleshooting
• Identify, troubleshoot, and resolve performance issues including expensive SQL queries, blocking/deadlocking, excessive waits, etc.
• Experience using monitoring software
• Experience working with users to resolve issues
• Understanding network interactions, including on premise to Cloud
• Understanding and experience working with ETL/ELT and data migration tools
• Experience with the Azure portal, Azure PowerShell
• Experience supporting Azure or other cloud-based solutions
• Experience in PowerShell, TSQL
• Solid understanding of Database concepts, backups and restore
Database Administrator Job Responsibilities:
• Install and maintain the performance of database servers.
• Develop processes for optimizing database security.
• Set and maintain database standards.
• Manage database access.
• Performance tuning of database systems.
• Install, upgrade, patching, and manage database applications.
• Diagnose and troubleshoot database errors.
• Engages with development teams throughout the software life cycle ensuring sustainable software releases and monitor application performance with the database
• Recommend and implement emerging database technologies.
• Create and manage database reports, visualizations, and dashboards.
• Capacity Planning
• Database reorganization planning
• Performance Tuning
• Be available for on-call support as needed.
Database Administrator Qualifications/Skills:
• Advanced knowledge of database security, backup and recovery, and performance monitoring standards
• Understanding of relational and dimensional data modeling
• Unix shell scripting skills
• Excellent written and verbal communication skills
• Understanding and experience working with Active Directory/Azure Active Directory
• Previously experienced in a mid- to large-size firm and supporting multiple versions SQL Server environments
• Database security management, e.g. Design & implement Security framework, incl. database roles
• Experience creating Synapse resources, including schema creation
• Synapse Dedicated SQL Pool Workload Management
• Advanced performance monitoring and troubleshooting experience.
• Identify future risks in the environment before they happen and work with team to get the work prioritized.
• Strong problem solving and troubleshooting skills, an ability to use various data collection tools and methodologies to analyze problems, determine root cause and develop solutions
• Ability to follow standards
• Understands the importance of security
• Advanced performance monitoring and troubleshooting experience.
Desired Skills
• Goldengate experience a plus
• Oracle experience a plus
Regards,
Muskan Sharma
ShiftCode Analytics Inc.,
5118 Sylvester loop Tampa,
Florida 33610
Contact 8135381180
Email: msharma@shiftcodeanalytics.com
URL: http://www.shiftcodeanalytics.com/
Hangout ID :
Musksha11@gmail.com
Linkedin: https://www.linkedin.com/in/muskan-sharma-472923229/
