Vacancy expired!
NO SPONSORSHIPSQL Database AdministratorSALARY: $100K - $125K plus discretionary bonusLOCATION: CHICAGO, IL Will work 2—3 days remoteMust 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 24x7 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 24x7 on-call support on a rotating basis
- Flexible to work off-hours, as required
- 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
- ID: #49542388
- State: Illinois Chicago 60642 Chicago USA
- City: Chicago
- Salary: $100,000 - $125,000
- Job type: Permanent
- Showed: 2023-03-25
- Deadline: 2023-05-16
- Category: Software/QA/DBA/etc