SQL Server Administrator/Engineer
Location
Greensboro, NC | United States
Job description
SQL Server Admin/Engineer
Location: Remote
Duration: Direct Hire
Pay: $80,000+ yearly
Job Description:
The SQL Server Administrator/Engineer will be responsible for the development and sustainment of the SQL Server environment and reporting/analytics platforms, ensuring their operational readiness (security, health, and performance), and providing leadership and support of this environment for developers and other consumers. Must be able to work independently and collaboratively and think forward to future growth and initiatives.
JOB RESPONSIBILITIES: - Manage SQL Server instances through multiple product lifecycle environments, from development to mission-critical production systems.
- Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, security, and recovery.
- Independently analyze, solve, and correct issues in real time, providing end-to-end problem resolution.
- Assist developers with complex query tuning and schema refinement.
- Refine and automate regular processes, track issues, and document changes.
- Lead architecture, development, and support of reporting and BI/Analytics platforms.
- Perform scheduled maintenance, support release deployment activities and critical production systems, after normal work hours if necessary.
- Test Disaster Recovery strategies / solutions to ensure RPOs can be met.
REQUIREMENTS: - Bachelor's degree in computer science, Information Technology, or related field, or the equivalent through a combination of education and work experience.
- Relevant Work Experience Required
- Min. 5 years' experience with relational database systems (SQL Server required). Experience with Non-relational/NoSQL environments a plus.
- Experience with Analytics, Reporting, and Integration platforms such as SSRS, Tableau, Power BI, SSIS (or other ETL).
- Experience with High Availability and Disaster Recovery options for SQL Server (required), Data warehousing is a plus.
- Experience working within a virtualized environment (vCenter a plus).
- Experience with cloud platforms such as Azure and AWS Integration a plus.
- ERP platform support experience is a plus (Microsoft Dynamics especially).
- Excellent SQL Server Administration skills: Backup/restore, index maintenance, partitioning and other archival strategies.
- Excellent SQL Server skills; proven ability working with T-SQL, stored procedures, and scripts.
- Excellent skills in constructing proficient queries and designing tables and databases.
- Exposure to ADO. Net / .NET in context of the data environment a plus, particularly EF and MARS
- Exposure to NO-SQL databases such as Mongo DB, Couchbase, Rabbit MQ (plus)
- Exposure to and/or familiarity with data warehousing (plus)
- Effective oral, written, and interpersonal communication skills
- Strong time management, organizational, prioritization, and planning skills
- Exceptional learning agility
Category Code: JN008
#zr
#Dice
Job tags
Salary
