Close
Login

Sr. SQL DBA

Longfinch
  • Oak Brook, IL

  • Post Date: May 15, 2020


Key Skills: SQL, DBA, SSIS, OLTP, T-SQL

  • Experience: 5 + Yrs
  • Domain: Information And Communication Technology
  • Job Type: Contract - Corp-to-Corp, Contract - Independent, Contract - W2

Job Description

• Troubleshoot database related issues and provide solutions to increase database system reliability and availability.
• Manage and maintain database Schemas using database modeling tools and deploy schema changes to Dev, QA, and Prod environments following the change control process.
• Manage and support production, QA, and Dev databases running on SQL Server, SSAS Cubes and other NoSQL databases.
• Assist with the development and automation of reports for business analysis and compliance purposes.
• Manage database security and maintain data safety and integrity.
• Ensure all database servers are backed up that meets RPO and RTO
• Assist with researching new database technologies and implement them to increase productivity and efficiency of database dependent applications.
• Assist with the development of ad-hoc SQL, stored procedures/views, and tune them to improve performance.
• Implement and maintain database/data archiving and retention process
• Develop DBA administration scripts using T-SQL, stored procedure, SSIS packages, and Power Shell scripts
• Document database environment and administration process
Qualifications:
• 5+ years of experience supporting MS SQL server or other OLTP database as a DBA
• 5+ years of experience developing T-SQL or other procedural languages
• 3+ years of experience working with database monitoring tools (SQL Profiler, Quest, RedGate, Idera, Foglight, PDBA, etc.)
• 3+ years of experience working with at least two scripting language: PowerShell, Python, Shell, Perl
• Must have administration experience with SQL Server SSAS, SSRS, and SSIS
• Must be able to work in Linux environment and know basic Linux commands and be able to use a Linux editor
• Knowledge of and experience with OLAP and NoSQL databases is a plus
• Must be able to work in a team environment
• Must have solid communication and interpersonal skills
• Understanding of Execution Services business and Options specific product knowledge is a plus
• Self-starter and ability to work with minimal supervision
• Willingness to learn new skills and take on new challenges
 


Share this vacancy

Related Jobs

Java Architect

Longfinch, Menands, New York

Key Skills Java, XML, SQL, JSF, JEE, Oracle Database, PL/SQL, Spring, HTML, JDBC, JSP, HTTP, MyBatis, Angular 2.x

Experience: 5 + Yrs

PeopleSoft Functional Analyst

Neshent Technologies, Ashburn, Virginia

Key Skills Peoplesoft, Acceptance Testing, Collaboration, Configuration, Desktop, Documentation, Best Practices, Budget, Business Analysis, Functional Analysis, Functional Design, Business Process, Business Requirements, Education, Estimating, Functional Requirements, Performance Management, Process Analysis, Software Configuration, Software Development, Requirements Analysis, HR Management, Implementation, Planning, QA, Traceability Matrix, Troubleshooting, Use Cases, Workflow, Writing, System Requirements, IT, Requirements Elicitation, SDLC, SQL, Software, Specification, Systems Design, Test Plans, Test Scenarios, Test Scripts, Training, FIT, PeopleSoft Application, EPerformance, ECompensation

Experience: 5 + Yrs

Pega Systems Architect

Longfinch, New York, New York

Key Skills Pega, System, Architecture, Cloud, EXT, Leadership, Microsoft Windows Azure, SQL, Systems Architecture, Microsoft SQL Server, Integration, CSSA

Experience: 5 + Yrs

Pega Systems Architect

Longfinch, New York, New York

Key Skills API Management, BMC Remedy, Cloud, Data Storage, Email, Installation, Leadership, Microsoft SQL Server, Microsoft Windows Azure, Pega, SQL, Security, Software, Systems Architecture

Experience: 5 + Yrs

Contact Longfinch

Oak Brook, IL Oak BrookIllinois 60523