SQL Server DBA
At a glance
Mid-level Data Architecture & Governance role at Confidential. Oak Brook · contract.
Pay not stated Data Architecture & Governance salary
dataroles summary, based on the employer's posting.
What you'll do
- Administer SQL Server and Oracle databases, keeping the client’s data environment running day to day
- Tune database performance, troubleshoot failures, and guide design choices for current and new systems
- Build and maintain complex ETL packages with SQL Server Integration Services
- Plan database capacity and growth across production, test, development, and disaster recovery environments
- Maintain backup, recovery, high-availability, and disaster-recovery approaches for critical systems
What you bring
- At least six years administering, developing, and maintaining Microsoft SQL Server databases
- Two or more years working with Oracle databases; Oracle experience is preferred rather than essential
- Hands-on SQL Server replication configuration experience
- Data warehouse experience, including SSIS ETL development, supports the core work
Who this fits
This contract-to-hire role is based onsite in Oak Brook, Illinois. You’ll take part in rotating, around-the-clock production support and coordinate with other IT teams. Applicants must be U.S. citizens or hold a green card or green-card EAD.
From the employer
For our premier client
Need for SQL Server DBA with experience in SQL Server Data Warehouse. Oracle skill is a definite plus.
Site: Oak Brook, IL
Contract to Hire (ONLY USC, GC/GC EAD)
JOB DESCRIPTION
Position Title: Database Administrator
Department: Information Technology
JOB SUMMARY: The DBA is a member of the IT Business Intelligence team and is responsible for directly supporting the daily administration of the SQL Server and Oracle databases used at our Client. He/she will manage and support our Client’s Data environment.
ESSENTIAL JOB FUNCTIONS:
§ Provide thought leadership on database architectural design of existing and new systems, database administration, performance monitoring tuning, troubleshooting problems and expansion.
§ Evaluate and implement products to enhance existing database solutions (reduce costs, improve efficiency, improve performance).
§ Review, enhance and develop backup and recovery strategies depending on SLA requirements.
§ Capacity planning and monitoring database growth.
§ Develop, maintain, and administer complex ETL using SQL Server (SSIS).
§ Design, maintain and ensure High Availability solutions including replication, clustering etc.
§ Design, implement and document Disaster Recovery strategies for critical business servers.
§ Perform capacity planning work on Production, UA, QA, DEV and DR environments.
§ Research improvements to improve overall system performance.
§ Participate in 24 X 7 Support of production environment and mission-critical applications with the Database Technology team on a rotational schedule.
§ Communicate and coordinate with other IT teams to successfully resolve support and maintenance issues.
§ Develop and enforce database standards and best practices including performance, security, monitoring policies and procedures.
§ Other duties as assigned.
MINIMUM QUALIFICATIONS:
§ 6 years of experience developing, maintaining and administering MS SQL Server databases.
§ 2+ years developing, maintaining and administering Oracle 9g/10g/11g/12c databases.
§ Experience configuring SQL Server replication required.
§ Experience with IBM CDC preferred
§ Experience with Business Intelligence and Data Warehouse products preferred.
§ ETL development experience with complicated SSIS Package coding and maintenance a plus
§ Experience with Data Modeling Tools as well as creating and maintaining data models preferred.
§ Goal driven, highly motivated, with a desire to take the lead and learn new skills.
§ Experience working with IBM InfoSphere Products (DataStage, QualityStage, Metedata Workbench, etc.) preferred.
§ Strong customer service skills and passion to work through obstacles to produce results.
§ Able to work in a projects-based, team environment.
§ IBM PDA/Netezza experience preferred.
§ Proficient in multi-tasking and managing multiple projects, able to meet target completion dates.
§ Able to be flexible and adapt to change.
The key qualifications are
1) 6 year experience as SQL Server DBA
2) 2 year Oracle DBA experience preferred not necessary
3) Good experience on Data warehouse including SSIS ETL experience
4) Experience with IBM Netezza a plus but not mandatory
Qualified prospect kindly share your updated resume to smano(@)divihn.com / can reach me on (630) 908 2919 if you would like to learn more about this opportunity over a quick phone call.
Data Architecture & Governance work from LinkedIn, X, Reddit and Upwork, in one list.
Each morning you get everything that fits, strongest first.
Data Architecture & Governance
Find me workBy the team behind dataroles.