What are the responsibilities and job description for the SQL Server DBA position at Confidential?
Company Description
For our premier client
Job Description
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.
Qualifications
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
Additional Information
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.