SQL DBA – SSIS/T-SQL Full Time

NO SPONSORSHIP

SQL Database Administrator

SALARY: $100K – $125K plus discretionary bonus

LOCATION: CHICAGO, IL Will work 2-3 days remote

Must have strong background in SQL development as well as database administrator. will consider a JR. DBA w/strong performance turning SSIS packages focus on report writing and generation stored procedure code development Windows VMWare 24×7 on-call support.

Looking for a candidate with a strong background in SQL development, as well as database administration experience. We will consider Junior DBA’s who are experienced with SQL and good at performance turning.

Responsibilities:

• Optimize stored procedures, functions and ad-hoc SQL
• Design, develop and implement internal data feeds, data reporting extracts and ETL processes between disparate systems
• Implement, create reports and provide general support for SQL Server Reporting services
• Monitor relational databases to optimize performance, resource use, backup/recovery, and physical implementation
• Review database objects and create and maintain change controls
• Monitor and maintain database security
• Migrate databases between Servers and various platforms
• Analyze and resolve SQL Server faults
• Document data flows, application specifications from a DB perspective and system procedures
• Implement and maintain data distribution and disaster recovery solutions, such as mirroring, replication, and log shipping
• Support highly-available and disaster recovery (HA/DR) database technologies (such as SQL Clustering and SQL Server Availability Groups across multiple data centers)
• Investigate and resolve reported application issues, escalating issues as necessary to the application owners
• Provide 24×7 on-call support on a rotating basis
• Flexible to work off-hours, as required

Qualifications:

• Bachelor’s degree in Computer Science or a related field or related experience
• A minimum of 5 years of experience with SQL
• Expert with SQL Server performance management and tuning, including identifying solutions that optimize SQL execution plans

SQL Server Administration experience including:

• Triggers
• Stored Procedure Code Development and Standardization
• Data Integration and Migration
• Management Studio
• SQL XML
• Database Auditing and Controls
• Strong knowledge of Windows OS
• Strong knowledge of physical and VMWare SQL configuration from an infrastructure perspective
• Strong understanding of security implementation
• Proven troubleshooting abilities
• Strong planning and analysis skills
• Strong documentation skills

Tagged as: sponsorship