Job added in hotlist
Applied job
Contract job
90-day-old-job
part-time-job
Recruiter job
Employer job
Expanded search
Apply online not available
Similar Jobs
Senior SQL Server DBA
Live Nation Worldwide, Inc.
Rolling Meadows, IL
Apply Now >
Senior SQL DBA
Chicago, IL
Apply Now >
Mid-level SQL DBA
Chicago, IL
Apply Now >
Senior Oracle DBA
Chicago, IL
Apply Now >
SQL Server DBA
Chicago, IL
Apply Now >
View more jobs in Chicago, IL
View more jobs in Illinois

Job Details

SQL database administrator

Location
Chicago, IL

Apply for this job






Profile

Listed By:
****Contact Name:
Sushmita Singh, Director, Recruiting and Delivery
E-Mail:
****
Tele****
Job location:
Chicago Illinois, USA
Job Type:
Contract
Job Description:
JOB TITLE: Database Admin
DEPARTMENT: IT Administration
WAGE CLASSIFICATION: Salary/Exempt
SUMMARY: This position is responsible for supporting and implementing all instances of MS SQL and their respective Operating Systems, new implementations, upgrades to reporting per specification, and general application changes including their rollouts to production. The successful candidate will possess a professional expertise in gathering application specifications from a variety of sources and successfully applying them to a production environment. This is a great opportunity for a visionary SQL database administrator who enjoys variety in day to day activities and a good mix of application development and team interaction.
DUTIES AND RESPONSIBILITIES
Enhance and modify SQL 2008 and 2012 production database tables, views, stored procedures and DTS and SSIS packages.
Convey application enhancement requests to programmer(s) and facilitate scheduled updates to production environments.
Support all departments with requests related to SQL database, such as ad-hoc reports, new database deployments, etc.
Maintains and monitors client data import/export processes.
Develop new and improve existing stored procedures, Data Transformation Services, SSIS and MS SQL Server databases.
Create and implement physical and logical designs for SQL Databases.
Deploy and configure Microsoft Operating systems.
Design and configure storage subsystems for SQL Databases.
Maintain and plan for outages for all MS Windows Servers hosting SQL Databases. ? Maintain and develop scripts in MS Visual Basic.
Support and develop multiple SQL Server Databases and data replication subsystems.
Maintain and monitor all redundancy and disaster recovery configurations for SQL systems including but not limited to data replication.
Collaborate with application developers to support the development process.
Ensure all developed SQL Server components function flawlessly in a production environment with stringent uptime standards.
Each week review top 10 most resource-intensive queries and suggest ways to improve them.
Implement, maintain and respond to critical job notifications on failure.
Identify and troubleshoot issues and tune all SQL databases for maximum performance.
Create and maintain up-to-date documentation of all SQL environments and processes associated with the database.
Keep track of usage trends of server and database resources on monthly basis for capacity planning and performance purposes.
Participate in an on-call rotation for Infrastructure support SKILLS/QUALIFICATIONS ? Minimum 5 years experience with MS SQL Server Standard and Enterprise 2008 and SQL 2012.
In-depth understanding and experience with Data Transformation Services and SSIS packages.
Proven experience deploying production quality MS SQL database, stored procedures, DTS and SSIS packages.
Experience supporting a 24/7 high availability environments.
Experience with backup strategies, clustering, high-availability, database storage design and replication solutions a must.
5 years of related experience, including functional requirements gathering and project planning.
Previous SQL 2008 and 2012 database design, administration and development experience required.
Strong T-SQL background for development of views, stored procedures and UDFs. ? Previous MS Access development experiences a plus.
Hands-on experience with MySQL a plus.
Understanding of ADO, DAO a plus.
Hands on experience with installation, configuration, troubleshooting and maintenance of Microsoft Operating systems: Windows Server 2003, 2008; and familiarity with Windows Server 2012 is a plus.
Understanding of storage subsystem considerations and configuration in relation to SQL Databases physical and logical architecture.
Microsoft Power BI Experience.
High level of enthusiasm for building and maintaining the business through the use of technology.
Personal sense of urgency and proven business acumen.
Open to new tasks and challenges.
Excellent oral and written communication skills.
EDUCATIONAL REQUIREMENTS:
Bachelor’s Degree required; preferably in Information Sciences or Computer Science
Job number: 109367
, Company id: 70376
Posted: 08/10/2018
Expires: 10/09/2018
Hit Statistics:
Job Page
The Legal Disclaimer

Company info

Sign Up Now - DBACrossing.com

Similar Jobs:
Database Administrator
Location : Chicago, IL
Database Administrator Legacy.com in Chicago IL 60606 USA Founded in 1998, Legacy.com is an innovative technology company that is the digital leader in the memorial and obituary market. Legacy.com collaborates with more than 1,500...
Modern DBA manager
Location : Chicago, IL
Job Description: Overview Applications span market connectivity, real-time market & firm-wide execution data, investor & fund accounting, trade management, clearing & settlement, rec & control, OTC products, cash management, treas...
SQL Database Administrator Job
Location : Chicago, IL
Database Administrator Chicago 5 mo. Contract-to-Hire *W2 only, we cannot provide sponsorship at this time* Summary: We are looking for a team-player to support our growing databases and applications. This individual will have thr...
I was facing the seven-year itch at my previous workplace. Thanks to EmploymentCrossing, I'm committed to a fantastic sales job in downtown Manhattan.
Joseph L - New York, NY
  • All we do is research jobs.
  • Our team of researchers, programmers, and analysts find you jobs from over 1,000 career pages and other sources
  • Our members get more interviews and jobs than people who use "public job boards"
Shoot for the moon. Even if you miss it, you will land among the stars.
DBACrossing - #1 Job Aggregation and Private Job-Opening Research Service — The Most Quality Jobs Anywhere
DBACrossing is the first job consolidation service in the employment industry to seek to include every job that exists in the world.
Copyright © 2018 DBACrossing - All rights reserved. 21