Senior Database Analysis Developer

Senior Database Analysis Developer

Wolters Kluwer India Private Limited
6-9 years
Not Specified

Job Description


The Intermediate level, under moderate supervision, analyzes, designs, creates and implements databases, including access methods, device allocations, validation checks, organization and security. Designs data models, logical and physical databases, data dictionaries and schemas. Assists in systems planning, scheduling and implementation. Initiates corrective action to stay on schedule. Installs, upgrades and tests moderately complex database software. Develops and implements database recovery plans and procedures.
Position Summary
Wolters Kluwer India Pvt Ltd (Pune) has a need for a Senior Database Analysis Developer for our Pune Global In-house center (GIC). Broad expectations from this role are as follows:
Technical Experience:

  • Experience in SQL Server is a must. Experience in MySql, Oracle and other DBs will be an added advantage.

  • Experience in SQL query tuning, optimizing SPs and functions.

  • Know how to get data from different sources like DMVs, XEvents and plan for SP optimization changes

  • Analyze deadlock graphs and fix.

  • Strong time management skills and excellent organizational skills with ability to juggle multiple demands without missing deadlines

  • Should be able to write, understand and fix complex SQL queries

  • Experience on various monitoring tools, corelating and analyzing test results to logical conclusions

  • Good communication skills and attitude

Experience

  • 6+ years of total experience in Database, mainly SQL server and relevant experience in Performance optimization of DB queries

Essential Duties and Responsibilities

  • Work on new SPs, functions and triggers when required.

  • Go through SQL plans, deadlock graphs from production and check for possible issues/fixes.

  • Provide guidance and support to Application Developers.

  • Participate in SQL code reviews

  • Write, understand and fix complex SQL queries

  • Technical troubleshooting and guidance to peers and juniors.

  • Mentor and guide team for new technologies, troubleshooting and analysis

  • Review test results and establish hypothesis to draw conclusions by providing in-depth result interpretation.

  • Stakeholder collaboration and communication.

  • Forecast application changes that affect scalability and capacity of production systems and suggest remediation steps.

  • Log and track defects, support triage

Wolters Kluwer (AEX: WKL) is a leading global provider of information, software, and services for professionals. We serve customers in more than 180 countries, operating through four divisions: Health Tax & Accounting Governance, Risk & Compliance and Legal & Regulatory. The Company is committed to helping professionals improve the way they do business and solve complex problems with confidence in an ever-changing world. Wolters Kluwer reported 2020 annual revenues of €4.6 billion, employs over 19,000 people worldwide and maintains operations in over 40 countries. The company is headquartered in Alphen aan den Rijn, the Netherlands. Wolters Kluwer shares are listed on Euronext Amsterdam (WKL) and are included in the AEX and Euronext 100 indices. For more information about our solutions and organization, visit www.wolterskluwer.com , follow us on Twitter , Facebook , and LinkedIn . EQUAL EMPLOYMENT OPPORTUNITY Wolters Kluwer and all of its subsidiaries, divisions and customer/business units is an Equal Opportunity / Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or any other protected status. GDPR

Similar Jobs

Career Advice to Find Better