Summary
Overview
Work History
Education
Skills
Certification
Professional Epitome
Timeline
Generic

Nitin Jain

Summary

Results-oriented Database Developer with 13 years of experience in designing, developing, and implementing data integration solutions using SQL Server Integration Services. Proficient in creating and maintaining ETL processes, data transformations, and data quality checks. Skilled in optimizing data workflows, troubleshooting performance issues, and ensuring data accuracy. Strong knowledge of SQL Server, T-SQL, and data warehousing concepts. Adept at collaborating with cross-functional teams and delivering high-quality solutions to meet business needs.

Database development professional with proven track record of designing, implementing, and maintaining robust databases to support critical business functions. Known for delivering high-quality database solutions and improving system performance. Collaborative team player with focus on achieving results and effectively adapting to evolving project requirements. Skilled in SQL, data modeling, and database optimization.

Overview

13
13
years of professional experience
1
1
Certification

Work History

Database Administrator

Northern Trust
07.2016 - Current
  • Designed, developed, and implemented ETL processes using SQL Server Integration Services to extract, transform, and load data from various sources into target databases.
  • Collaborated with business analysts and stakeholders to gather requirements and translate them into technical specifications.
  • Created data mappings, transformations, and workflows to ensure accurate and efficient data integration.
  • Implemented data quality checks and validations to identify and resolve data issues during the ETL process.
  • Developed and optimized SQL queries, stored procedures, and views in T-SQL for data transformation and cleansing.
  • Performed performance tuning and optimization techniques to improve the efficiency and speed of data workflows.
  • Implemented error handling and logging mechanisms to capture and report errors during data integration processes.
  • Worked closely with database administrators to ensure the smooth execution of SSIS packages and maintain database performance.
  • Collaborated with report developers to provide them with reliable data sources for SQL Server Reporting Services (SSRS) reports.
  • Assisted in designing and implementing data warehouse structures and schemas for efficient storage and retrieval of data.
  • Kept up-to-date documentation of SSIS packages, data mappings, and system configurations.
  • Stayed informed about the latest advancements in SSIS and recommended process improvements to enhance data integration practices.
  • Environment: SQL Server 2014, SQL Server 2012 R2, SQL Server 2008, Windows 2008/2003 Server, SQL Query Analyzer, SQL Profiler.
  • Administered database systems, ensuring optimal performance and availability for critical financial applications.
  • Developed and implemented backup and recovery strategies to safeguard data integrity and accessibility.
  • Monitored database health, diagnosing issues proactively to minimize downtime and enhance reliability.
  • Collaborated with cross-functional teams to design database solutions that support business objectives and scalability.
  • Automated routine maintenance tasks, improving efficiency and reducing manual intervention requirements.
  • Mentored junior team members on best practices in database management and optimization techniques.
  • Conducted performance tuning of databases, enhancing query response times and overall system efficiency.
  • Evaluated new database technologies, recommending upgrades that align with organizational goals and industry standards.
  • Streamlined backup and recovery processes, enhancing overall system stability and availability.
  • Ensured database security with implementation of role-based access control and regular vulnerability assessments.
  • Reduced data retrieval times for business users by creating indexed views and optimizing stored procedures.
  • Built databases and table structures for web applications.

Database Administrator

Morgan Stanley
04.2012 - 06.2016
  • Monitoring the server for High availability of the servers.
  • Solving the request raised by user support.
  • Work closely with IT business analysts, Development teams and other project leads to understand requirements to deliver OLTP, Data Reporting & Warehouse systems related projects.
  • Responsible for Database and ETL support, troubleshooting, planning and migration.
  • Experience to create table, index, views, alias and tablespaces as per user request.
  • Database Mirroring and database level High Availability.
  • Experience writing Stored Procedures, Queries, Tuning, Scripts.
  • Experience to Write backup, restore and clone procedures.
  • Experience to Archiving millions of data which comes daily from OLTP server to archiving server.
  • Performed reorganization on the tables and table statistics.
  • Supported Autosys jobs daily.
  • Experienced with replication and supporting multiple servers.
  • Daily database operations and Support of production environment.
  • Environment: IBM DB2 9.7, Unix, DB Artisan, Autosys, JIRA, DB2TS.
  • Implemented comprehensive data retention policies that met regulatory requirements while minimizing storage costs.
  • Established proactive monitoring solutions that alerted administrators to potential issues before they escalated into major problems.
  • Administered, supported, and monitored databases by proactively resolving database issues and maintaining servers.
  • Optimized database operational efficiency by implementing automated backup and recovery procedures.
  • Contributed to successful audits, ensuring full compliance with data governance and regulatory requirements.
  • Reduced system downtime significantly, employing proactive monitoring and maintenance of database systems.
  • Administered database systems, ensuring optimal performance and availability for critical financial applications.
  • Created a robust disaster recovery plan to ensure business continuity in the event of hardware failures or natural disasters.
  • Delivered successful database migration projects, ensuring seamless transitions with minimal disruption to business operations.
  • Wrote and maintained technical and functional specifications to document database intentions and requirements.
  • Developed and implemented backup and recovery strategies to safeguard data integrity and accessibility.
  • Implemented capacity planning strategies to accommodate growth in data volume without compromising system performance or reliability.
  • Enhanced reporting capabilities by designing efficient ETL processes that improved data accuracy and completeness.
  • Implemented BI solution framework for business intelligence projects.
  • Ensured database security with implementation of role-based access control and regular vulnerability assessments.
  • Created and updated database designs and data models.
  • Ensured high availability and disaster recovery capabilities, establishing and testing robust backup and failover strategies.

Education

Bachelor of Engineering - Information Technology

RGPV University
01.2011

Skills

  • SQL Server Integration Services (SSIS)
  • T-SQL
  • Data integration and ETL processes
  • Data transformation and cleansing
  • Data warehouse design and implementation
  • Performance tuning and optimization
  • Data quality checks and validation
  • Error handling and logging
  • SQL Server Reporting Services (SSRS)
  • SQL Server Analysis Services (SSAS)
  • Database administration tasks
  • Microsoft Azure services
  • Scripting languages (eg, PowerShell, Python)
  • Excel
  • PL/SQL
  • Oracle Database
  • SQL
  • Stored Procedures
  • Functions
  • Triggers
  • Performance Tuning
  • Data Modeling
  • Database Design
  • Query Optimization
  • Data Integrity
  • Database Administration
  • Quick learner with good grasping ability
  • A high tolerance of stress and enjoys responsibilities
  • Action-oriented and result-focused Career

Certification

  • Microsoft Certified: Azure Administrator Associate (AZ-104)
  • Microsoft Certified: Data Engineering on Microsoft Azure (DP-203)

Professional Epitome

  • Understand business issues and translate these into technical needs.
  • Gather and organize large and complex data assets, perform relevant analyses and modeling.
  • Ensure Analytics model quality assurance and validate them (peer validation)
  • Define model monitoring criteria.
  • Communicate hypotheses and findings in a structured way.
  • Partner with Data Analyst team to present outcomes of our models
  • Partner with Data Steward to identify necessary data to build our models.
  • Partner with Data Engineer to build necessary data pipelines.
  • Work closely with Data industrialization team (IT) to ensure that the POC will be eligible for industrialization.
  • Explain to key executive the business value of our programs and drive the arbitration process.
  • Lead discussions with all project members (Data Analyst, ML Engineer, Data Engineer...)
  • Actively contribute to Data Science community
  • Have 8+ years of hands-on experience in the software industry and proficient in Microsoft technologies such as MS SQL Server 2008R2, 2012/14/16 and Power BI, SSIS and SSAS.
  • Skilled at Azure Data Factory, Blob Storage, SQL DW and moving the data to Blob and then to SQL DW using data transformation/activity and knowledge in Big Data Analytics.
  • Design and maintain well-structured relational database schemas.
  • Create automated pipelines for ETL, Model Training and Scoring.
  • Research and develop new data storage architectures for growing data volumes.
  • Maintain excellent documentation for understanding and accessing data storage.
  • Analyze existing in-process data to inform process development.
  • Collaborate daily with other members of Manufacturing/Industrial Engineering
  • Proficiency in SQL and relational database design
  • Proficiency in engineering investigation
  • Proficiency in data ETL workflows with programming/scripting languages with SSIS and ADF.
  • Proficiency creating process documentation.
  • Experience with multiple data storage architecture paradigms
  • Exemplary verbal and written communication skills
  • Exemplary written communication skills
  • Well organized with meticulous attention to detail
  • Mastery of Word, Excel, PowerPoint, Visio 2
  • Proficient in working with SQL Query Analyzer, SQL Server Management Studio and Business Intelligence Development Studio, Indexes and SQL Profiler

Timeline

Database Administrator

Northern Trust
07.2016 - Current

Database Administrator

Morgan Stanley
04.2012 - 06.2016

Bachelor of Engineering - Information Technology

RGPV University

Similar Profiles

CREATE PROFILE
Nitin Jain