SQL Dba - India - Bloom Consulting Services

Bloom Consulting Services

Verified Company

India

2 weeks ago

Posted by:

Deepika Kaur

beBee Recuiter

Description

NA

Experience

- 5 years
Offered Salary

Notice Period

Not Disclosed

Summary:

Responsible for leading the design, installation, maintenance, and upgrades of the Firm s SQL server databases.
Work closely with the SQL Manager to ensure daily maintenance; logging, reporting, backups, updates, etc. are handed in a timely and efficient manner.
Monitoring and analysing performance metrics, and allocating database resources to achieve optimum database performance.
Proactively monitor the database systems to ensure secure services with minimum downtime.
Supporting and closely following plans and instructions from the SQL Manager in support of all SQL operations delegated to the administrator.
Assisting in troubleshooting and problemsolving SQL development and runtime issues, improvement and maintenance of all databases, to include rollout and upgrades.
Additional duties include working with related process stakeholders to identify and resolve related problems and issues as well as realize efficiencies as a result of process and system improvements.

Essential Functions:

Develop, test, document, implement, and maintain SQL infrastructure for departmental or Firm initiatives.
Troubleshoot, support and maintain all SQL systems.
Analyse and identify timesensitive system problems that could have an impact on business operations.
Communicate effectively to nontechnical customers and sponsors.
Proactively and effectively communicate potential problems, solutions and accomplishments to management.
Analyse existing processes and identify dependencies and potential break points, and recommend and implement improved technical solutions.
Partner with internal customers to understand requirements in business terms and translate those requirements into technical solutions, includes developing new capabilities as well as break/fix.
Develop specific SDLC documentation.
Ensure approval of technical solutions from IT management and key stakeholders.
Write functional specifications.
Continuously develop technical and professional skills.
Evaluate user requests for new / modified programs.
Install and test programs; monitor program performance after implementation.

Requirements:

3+ years of SQL Server database administration experience.
4 years degree in computer science, computer engineering, computer technology, management information systems, or related fields of study or equivalent relevant experience
Must have significant technical expertise in the use of SQL database technology.
Experience in the installation and configuration of Microsoft SQL Server
Experience in database administration, database monitoring and tuning, and physical database development
Understands the principles, theories, practices and techniques of SQL Server database administration
Extensive experience managing multiple MS SQL 2005/2008/2012/2014 servers on enterpriseclass server clusters running Windows 2003/2008/201
Practical experience in monitoring and tuning a database to provide a high availability service
Experience with T-SQL, DTS, SSIS and stored procedures
Practical experience in managing internal and external Microsoft SQL Server database security
Experience with Replication, Log Shipping, Database Mirroring, and Availability Groups.
Understanding of High Availability, Business Continuity, and Disaster Recovery concepts as they relate to Open Systems architecture
High aptitude for complex problem analysis and resolution
Experience in the following knowledge areas, competencies, and experience: Applications Administration, Systems Administration, Database Administration, Systems Analysis, Business Analysis and Project Management.
Law firm experience a plus.
Excel, PowerPoint, Word, Visio, MS Project.
ITIL and process knowledge is highly encouraged.