| $50/h :: Senior SQL DBA--------------Tampa, FL (remote) at Tampa, Florida, USA |
| Email: [email protected] |
| Job Title Senior SQL DBA Relevant Experience (in Yrs) 6 Technical/Functional Skills Refer to Roles and Responsibilities section Experience Required 8 Roles & Responsibilities More than 6 years of experience in Database Administration for SQL Server (2008R2/2012/2014/2016/2017/2019) in a multi-site enterprise environment. Must have experience on On-premises, AZURE IaaS, PaaS instances. Strong experience on analyzing and migrating the infrastructure (including the application and database instances) from On-premises to Azure cloud infrastructure. Must have experience on analyzing the infrastructure to set up the environments as per the defined project scope. Strong experience in troubleshooting and resolving SQL Server instances and related technologies integrations and database problems. Must have experience in installing and configuring ADF (Azure Data Factory) Must have experience in writing the data pipelines Must have experience in migrating the data from on prem to ADF Must have experience in configuring the SQL DB in Azure IaaS and PaaS environments Should be strong on analyzing the application and database connectivity issues including the drivers and protocols used. Must have experience configuring and managing SQL Server clusters, Availability Groups and Always On. Strong experience in Performance Tuning and Optimization (PTO) of SQL Server databases, using native monitoring and troubleshooting tools. Must have experience with backups, restores and recovery models for SQL Server. Must have experience with SQL Server Replication. Must have strong experience on security models (In-transit, data-at-rest, On-fly encryptions) based on data classifications. Must have experience in implementing using Azure Key vault and encrypting the DB. Strong experience on High Availability (HA) and Disaster Recovery (DR) options for SQL Server, including AlwaysOn Availability groups, SRM cluster etc. Must have experience with SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS). Must have experience in implementing operational automation using scripts. Must have experience in how indexes are used, missing indexes, index management, type of fragmentations and statistics on SQL Server. Must have experience working with Windows server, including Active Directory and proper disk configurations. Should be working as an individual contributor, decision maker and take ownership. Must have strong experience on T-SQL and PowerShell scripting. Must have knowledge on MongoDB installation and configuration on windows operating systems and Linux boxes. Basic knowledge on MongoDB security models. Basic knowledge on MongoDB On-fly and at-rest configurations and limitations. Must have excellent communication and documentation skills. Must have the ability to work well in a team environment and follow standard operating procedures. Generic Managerial Skills Ability to manage cross functional, and distributed team (across multiple countries and time zones) Leads/mentors other DB engineers and shares knowledge to make sure they meet technical qualifications required for their positions Assists in coaching junior staff, by helping them to make decisions, solve problems, manage meetings and set goals, provides feedback on testing-related tasks, delegates and assigns testing responsibilities Work Location Tampa, FL Regards, Dharmendra Rana Senior Technical Recruiter Quantum World Technologies Inc. 4281 Katella Ave, Suite # 102 Los Alamitos, CA , 90720, USA 250 Yonge Street, Suite #2201, Unit #10, Toronto, ON, M5B 2L7, Canada 128 City Road, London, EC1V 2NX, United Kingdom.(U.K) www.quantumworldit.com Office: 805-222-0532*217 E: [email protected] Linkedin: https://www.linkedin.com/in/dharmendra-rana-8545b893/ -- Keywords: database information technology California Florida |
| [email protected] View all |
| Fri Sep 08 19:43:00 UTC 2023 |