Azure SQL Engineer - CTEH_R1513-3762

Role Details

This job was posted by https://www.arjoblink.arkansas.gov : For more information, please see: https://www.arjoblink.arkansas.gov/jobs/3706161 The <b>Azure SQL Engineer</b> position as CTEH, LLC is for a senior-level SQL Server DBA providing operational database management tasks for select clients. The DBA will be self-sufficient in terms of their abilities to exceed customer expectations while being part of a team to lend support and assistance when needed. Database support will include day-to-day duties for proper database maintenance along with proactive measures to maximize the database availability and performance. This position includes aspects of 24 x 7 support in conjunction with other team members.<br> <br> <b>Job Type</b>: Full-time<br> <br> <b>Pay Range:</b> $115,000.00 - $145,000.00<br> <br> <b>BENEFITS</b> <br> <br> <ul> <li>Health Insurance with PPO/HDP options<br></li> <li>Dental Insurance<br></li> <li>Vision Insurance<br></li> <li>Flexible Spending Account (with PPO)<br></li> <li>Health Savings Account (with HDP)<br></li> <li>Life Insurance/AD&D Insurance<br></li> <li>Short- & Long-Term Disability<br></li> <li>401-K Retirement Savings Plan<br></li> <li>Short Term Incentive Pay<br></li> <li>Annual Incentive Compensation Plan<br></li> <li>Paid Time Off<br></li> <li>Paid Holidays<br></li> <li>Paid Sick Leave<br></li> <li>Paid Parental Leave<br></li> <li>Professional Development Assistance<br></li> <li>Employee Assistance Program<br></li></ul>Vaccination against Covid-19 is strongly preferred. All employees will be subject to policies and procedures of the Company that may be dependent on vaccination status.<br> <br> <b>ACTIVITIES/TASKS/SCOPE</b> <br> <br> <ul> <li>Database Administration for SQL Server installations including capacity planning, installing, upgrading, configuration and patching, and all functions to provide high availability, high performance, and high security;<br></li> <li>Implement and support housekeeping procedures such as backups, integrity checking<br></li> <li>Production and maintenance of high-quality documentation.<br></li> <li>Providing overnight and off-hours support as part of a support team.<br></li> <li>Experience with setup and support database clustering, mirroring, replication, and log shipping in Windows enterprise environment.<br></li> <li>Knowledge of table partitioning and archiving mechanisms.<br></li></ul> <b>EDUCATION/EXPERIENCE</b> <br> <br> <ul> <li>Minimum of 5 years of experience as a SQL Server DBA in SQL server 2005 or above<br></li> <li>Excellent understanding of SQL with experience with performance monitoring, analysis, and tuning of relational databases. This includes the use of T-SQL, profiler, tuning advisor, indexes, statistics, query plan analysis<br></li> <li>Previous consulting experience required<br></li></ul>Experience with:<br> <br>Creating triggers, stored procedures, and complex join statements<br> <br>Migrating data to/from other data sources using DTS/SSIS/SSRS and deploying/maintaining packages/jobs.<br> <br>Engineering DR/BC and backup solutions including full, differential, transactional backup, backup mirroring, and automated maintenance jobs with alerting.<br> <br>Experience with Azure, specifically in the areas listed below<br> <br>Planning and implementing data platform resources<br> <br>Implementing a secure environment<br> <br>Monitoring and optimizing operational resources<br> <br>Optimizing query performance<br> <br>Performing automation of tasks<br> <br>Planning and implementing a High Availability and Disaster Recovery (HADR) environment<br> <br>Performing administration by using T-SQL<br> <br> <b>PROFESSIONAL SKILLS/LICENSES/CERTIFICATIONS</b> <br> <br> <ul> <li>Ability to function well in a team working independently while managing time and priorities in a 24 X 7 DBA remote support environment.<br></li> <li>Ability to work overtime as needed<br></li> <li>Ability to maintain confidentiality and the highest degree of professionalism<br></li> <li>Ability to multi-task, prioritize and meet deadlines<br></li> <li>Possess excellent problem-solving and analytical skills with significant amount of information<br></li> <li>Ability to understand and follow written and verbal directions<br></li> <li>Current, valid, unrestricted driver's license (required)<br></li> <li>Must possess strong interpersonal skills.<br></li></ul> <b>PHYSICAL DEMANDS AND WORK ENVIRONMENT</b> <br> <br>The <b>physical demands</b> described below are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.<br> <br> <ul> <li>Sitting, standing, and walking<br></li> <li>Infrequent lifting to 10 pounds<br></li> <li>Infrequent overhead lifting of over 10 pounds<br></li> <li>Bending, stooping, climbing<br></li> <li>Keyboarding/typing<br></li> <li>Reading effectively from a computer screen and/or paper copy<br></li></ul>The <b>work environment</b> characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabili

Montrose Environmental Group Inc. provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.