SQL Server DBA

Chicago 22 months agoFull-time External
Negotiable
Dice is the leading career destination for tech experts at every stage of their careers. Our client, Request Technology, LLC, is seeking the following. Apply via Dice today! NO SPONSORHSHIP SQL Database Administrator II SALARY: $125k - $140k flex LOCATION: Chicago, IL (Must live in the Chicago area) Hybrid 2 days onsite 3 days remote Looking for a SQL Server DBA. SQL 2014, 2016, 2017, 2019. You will write debug maintain scripts transact-sql ssis ssrs function as primary or backup dba. Level 3 support The Database Administrator II is responsible for the deployment, administration, and maintenance of all databases hosted on the Microsoft SQL Server platform. This person will work as a member of the firm wide database administration team which provides advanced Level 3 support for the SQL Server environment. Essential Functions • Support, administer, and maintain development, test, and production environments. • Work with project teams comprised of project managers, developers, application vendors, application engineers, and application users to provide DBA support for database deployments and upgrades. • Create and maintain SQL Server Integration Services (SSIS) packages. • Review, deploy, and administer security for SQL Server Reporting Services (SSRS) reports. • Troubleshoot server and database performance problems and identify solutions to resolve the problems. • Administer SQL Server security and protect sensitive data. • Adhere to the Firm s IT Service Delivery standards and Change Control processes. • Adhere to the Firm s Security and Governance requirements across all administered applications. • Develop and maintain troubleshooting, configuration, and integration documentation for administered systems. • Function as a primary or backup DBA for assigned applications. Have a working knowledge of all database applications. • Work with server engineers, storage engineers, and network engineers to resolve issues and prevent downtime. • Provide 24x7 operational support. On-call support responsibilities are rotated among the members of the DBA team. Qualifications & Requirements The Database Administrator II must have experience of Microsoft SQL Server Administration. • Database administration experience with SQL Server 2014, 2016, 2017, and 2019. • Proficiency with Transact-SQL including the ability to write, debug, and maintain scripts, stored procedures, functions, and views. • Experience configuring and maintaining replication, log shipping, and database mirroring. • Experience installing and configuring SQL Server on virtual machines and stand-alone servers. • Experience developing SSIS packages. • Experience optimizing and administering SSRS reports. • A solid understanding of normalized database design and modeling. Technologies/Software Core Technologies: • Microsoft SQL Server (Enterprise, Standard, & Express editions) • Database Engine, Integration Services, Reporting Services • Replication, Log Shipping, & Database Mirroring • Transact-SQL • Microsoft Windows Server (Enterprise & Standard editions) • Microsoft Fail-over Clustering