Sql Server Replication DBA Remote

Insight Global - Chicago, IL

Full-time

Chicago, IL

Administrative and Support Services

About the position

The Database Administrator (DBA) will provide comprehensive support for database systems, focusing on performance tuning, capacity monitoring, and database replication. This role involves working with both on-premise and cloud-based databases, ensuring high availability and disaster recovery, while also collaborating with application development teams to optimize database performance and maintain coding standards.

Responsibilities

• Optimizing and tuning database systems
• Ensuring adherence to storage, archiving, and back-up recovery procedures
• Backup recovery testing of recovery procedures and archiving databases
• Disaster recovery testing
• Troubleshooting database issues and performing database impact analysis for proposed changes
• Controlling access permissions and privileges
• Altering tables and schema structure as required
• Working with application development teams to develop stored procedures, triggers, and code to support enterprise applications
• Executing database release management processes and coordinating maintenance of development, testing, and production environments
• Physical database design
• Other duties as assigned

Requirements

• BS Degree in Computer Engineering, Computer Science or related field/technical experience
• Expert administration/engineering skills in Windows 10 OS technologies
• Minimum of 3 years supporting Windows desktop/server operating systems and technologies, including Active Directory, DNS and DHCP and group policies
• Advanced knowledge in automating for Windows platforms leveraging PowerShell, ActiveBatch, and SCCM or MDT
• Minimum of 7 years of experience in administering multi-terabyte databases (PostgreSQL, Yellowbrick, Netezza, DB2, SQL Server, Oracle)
• Proficiency with SQL, Mongo, PL/SQL, PL/pgSQL, UNIX Shell, PowerShell, PERL
• Strong technical ability and outstanding troubleshooting skills
• Ability to research emerging technologies and make recommendations that benefit our business
• Strong customer service orientation

Nice-to-haves

• Experience in administering a multi-terabyte data warehouse is preferred