Job Description :
SQL Server DBA with DTS, SSIS
Little Rock, AR, United States
Long term - W2 or C2C
Duties and Responsibilities
* • Perform Microsoft SQL database administration including software installations/configurations for SQL Server 2012/2014 to 2016/2017 including SSDT, SSIS, SSRS, SSAS and peripheral features/products such as log shipping, mirroring, and maintenance packs (dbcc, backups, re-indexing
* • Troubleshoot complex systems to identify bottlenecks (SQL, IO, hardware, query related, etc and resolve database related issues.
* • Responsibilities include capacity planning work (on Production, UAT, DEV and DR environments); platform migration and monitoring database growth and design, maintaining and ensuring High Availability solutions including replication, clustering, performance tuning etc.
* • Duties include developing and enforcing database standards and best practices including performance, security, monitoring policies and procedures along with researching improvements to enhance overall system performance.
* • Provide hands-on training, mentoring and support to current ADE – Network & Server Administration staff with Microsoft SQL Server databases.
A successful candidate may have experience with:
* • 8+ years of experience developing, maintaining and administering Microsoft SQL Server databases.
* • Bachelor’s degree in Computer Science/Information Science or equivalent work experience.
* • Involved in prior enterprise-level databases migrations and deployments.
* • Experience required in configuring SQL Server replication across data center.
* • Hand-on experience with MS SQL Server 2017/2016; 2014; 2012 versions.
* • Hand-on experience with SQL monitoring tools – Red Gate; SQL Sentry; etc.
* Experience with Business Intelligence and Data Warehouse products
* Development experience with complicated DTS/SSIS Package coding and maintenance
* Experience with Data Modeling Tools as well as creating and maintaining data models
Desired Skills
* K-12 experience