Sorry, this job is no longer accepting applications. See below for more jobs that match what you’re looking for!

SQL DBA

Expired Job

Humanoko Inc. Chicago , IL 60654

Posted 4 months ago

RESPONSIBILITIES
Support, administer, and maintain development, test, and production environments.
Work with project teams comprised of project managers, developers, application vendors, application engineers, and application users to provide DBA support for database deployments and upgrades.
Create and maintain SQL Server Integration Services (SSIS) packages.
Review, deploy, and administer security for SQL Server Reporting Services (SSRS) reports.
Develop and maintain troubleshooting, configuration, and integration documentation for administered systems.
Function as a primary or backup DBA for assigned applications. Have a working knowledge of all database applications.
Work with server engineers, storage engineers, and network engineers to resolve issues and prevent downtime.
Provide 24x7 operational support. On-call support responsibilities are rotated among the members of the DBA team.
REQUIREMENTS
The SQL DBA must have a BA/BS in computer science, related field, or equivalent experience with 5+ years' experience of Microsoft SQL Server Administration.
The ideal candidate must have good judgment, problem-solving, oral, written and interpersonal communication skills, as well as the ability to work in a fast-paced environment and build positive working relationships. In addition, candidates must be self-motivated, organized, and able to multi-task and effectively prioritize competing demands.
Database administration experience with SQL Server 2008 R2, 2012, 2014 and 2016.
Proficiency with Transact-SQL including the ability to write, debug, and maintain scripts, stored procedures, functions, and views.
Experience configuring and maintaining replication, log shipping, and database mirroring.
Experience installing and configuring SQL Server on virtual machines and stand-alone servers.
Experience developing SSIS packages.
Experience optimizing and administering SSRS reports.
A solid understanding of normalized database design and modeling.
Nice to Haves
A working knowledge of Idera, RedGate, and SentryOne database tools.
Proficiency with PowerShell scripting.
Experience with SSRS report development.
Experience with setup and administration of Always On availability groups.
Experience installing and configuring SQL Server on fail-over clusters.
-Thank you!

Skills:
SQL Dba
Permanent
Full time


See if you are a match!

See how well your resume matches up to this job - upload your resume now.

Find your dream job anywhere
with the LiveCareer app.
Download the
LiveCareer app and find
your dream job anywhere
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Sr SQL Server DBA

Kpmg

Posted 3 days ago

VIEW JOBS 12/13/2018 12:00:00 AM 2019-03-13T00:00 Known for being a great place to work and build a career, KPMG provides audit, tax and advisory services for organizations in today's most important industries. Our growth is driven by delivering real results for our clients. It's also enabled by our culture, which encourages individual development, embraces an inclusive environment, rewards innovative excellence and supports our communities. With qualities like those, it's no wonder we're consistently ranked among the best companies to work for by Fortune Magazine, Consulting Magazine, Working Mother Magazine, Diversity Inc. and others. If you're as passionate about your future as we are, join our team. KPMG is currently seeking a Sr. SQL Database Administrator to join our Deal Advisory organization. Responsibilities: * Provide technical support of database environments/applications, including software installation, database creation, upgrades, patches, problem diagnosis, performance monitoring, database maintenance, process automation, evaluation, and tuning recommendations * Develop, implement and support backup/restore, disaster recovery and data replication procedures and exercises * Participate in all aspects of the lifecycle for database environments; and in the implementation of application requested database code and configuration changes in supported database environments * Contribute in the creation of new policies, procedures, projects and processes * Evaluate, document, and recommend database-related software products within technical architecture framework * Interact with various technology teams regarding work requests submitted, participate in the creation of new policies, procedures, projects, processes and participate in all aspects of the lifecycle for database environments Qualifications: * Minimum of five years of experience working with very large tables and datasets * Bachelor's degree from an accredited college/university or equivalent work experience * Proficiency in T-SQL creating stored procedures, functions, views, advanced queries and strong ability to navigate through and optimize existing stored procedures * Knowledge of database design principles, index management, integrity checks, and statistics; demonstrated ability in performance tuning, query optimization using SQL Server native tools (DTA, Profiler, and System Stored Procs, DMV's, DMF's) * Experience in SQL 2012/2014/2016, SSRS, SSIS, SSAS * Ability to provide on call 24/7 emergency off-hours support of critical systems for database problem resolution and recovery, as well as production applications KPMG LLP (the U.S. member firm of KPMG International) offers a comprehensive compensation and benefits package. KPMG is an affirmative action-equal opportunity employer. KPMG complies with all applicable federal, state and local laws regarding recruitment and hiring. All qualified applicants are considered for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, protected veteran status, or any other category protected by applicable federal, state or local laws. The attached link contains further information regarding the firm's compliance with federal, state and local recruitment and hiring laws. No phone calls or agencies please. Kpmg Chicago IL

SQL DBA

Expired Job

Humanoko Inc.