arrow

Senior SQL DBA

  • 7 or more years of experience working in a data function or equivalent position where primary responsibility is working with data, database design and data development is the primary responsibility.
  • 7 or more years of hands-experience with Microsoft SQL Server.
  • 5 or more years of experience with SQL Server Integration Services (SSIS).
  • Expertise in data warehousing and data modeling methodologies, tools and best practices.
  • Excellent communication skills and ability to translate the complex to simple and easier terms for business leaders and users of data.
  • Serves as technical lead for strategic and enterprise level data driven projects.
  • Perform day-to-day operations for all SQL Server databases, including monitoring and maintenance, problem investigation and resolution, backup creation and maintenance, database optimization and tuning, etc.
  • Develop complex ETL (extract, transform and load) SQL scripts and SSIS packages to gather data from various databases and systems to support data integration projects and build out our enterprise data warehouse.
  • Create enterprise level end-to-end data flow diagrams and logical data models.
  • Develop and review complex SQL, T-SQL scripts, stored procedures for various reporting and data development projects.
  • Perform ad-hoc data analysis and assist with ad-hoc reporting.
  • Develop a database archiving and partitioning strategy to improve performance and enforce retention.
  • Perform data cleanup and data migration as needed for various projects.
  • Provide guidance to cross-team and team members in database best practices and procedures.
  • Apply best practices to manage security, and enforce encryption, masking and audit processes for all databases.
  • Assist with sourcing and implementing a Master Data Management system.
  • Assist developers with complex query tuning and schema refinement.
  • Proactively identify issues, bottlenecks, gaps, or other areas of concern or opportunity and work to either directly affect change, or advocate for that change by working with peers and leadership to build consensus and take action.
  • Perform critical maintenance, deployment, and release support activities, including occasional off-hours support.
  • Support IT audits, and perform periodic DR exercises.
  • Adaptable team player with strong collaboration skills and a focus on results and value delivery.
  • Passion for engineering excellence, curiosity and demonstrated ability of continuous learning.

Education:

Bachelor’s degree in computer science or related engineering field (Masters is a plus).

Experience:

8 - 10 years

City of Job:

Pune, India

Job Type:

Fulltime / Permanent

Last Date to Apply:

Skills Required: SQL Server databases, ETL (extract, transform and load) SQL scripts, SSIS, Data flow diagrams, Logical data models, T-SQL scripts, Data analysis, Reporting, Master Data Management system, Query tuning, Schema refinement.