SUMMARY

• Overall 10 years of experience in database designing, development, administration, performance tuning, business intelligence and reporting using MS SQL Server, Oracle, Teradata, Sybase, DB2.
• MS SQL Server (Versions: 2000, 2005, 2008, 2012 and 2014)
• Expertise in S tored procedures, Functions, Triggers, Indexes, User - defined functions, Common Table Expressions (CTE) and Views .
• Expertise in SQL Profiler, Performance Monitor, Performance Tuning, Query Optimization, Dynamic Management Views (DMV), Tuning advisor and Database Consistency Checks.
• Expertise in installing, configuring, managing, upgrading, migrating, monitoring and troubleshooting .
• Experience in Clustering, Always-On , Replication, Log Shipping and Database Mirroring.
• Experience in database creation, backups/recovery, user/schema creation, SQL Server agent jobs and space management.
• Experience in DTS and SQL server integration services (SSIS) / ETL technologies.
• Knowledge in building data cubes by implementing SQL Server OLAP services in SSAS and SQL Server reporting Services (SSRS).
• Good understanding of data warehousing, dimensional data modeling and schemas such as star, snowflake schema.
• Good knowledge on entity relationship diagram (ERD) and data modelling.
• Experience in database designing, creating views and writing SQL queries.
• Experience in creating reports using advanced techniques like rank, row number.
• Experience in PL-SQL creating stored procedures, functions and packages.
• Experience in ETL tool for developing graphs.
• Experience in Business Application Development involving Design, Development and Testing of large commercial applications.
• Expertise in report generation using Crystal Reports and Fast Reports.
• Experience in version controlling tools like TFS and VSS .
• Experience with SDLC, Agile Development practices, sprint planning and daily scrum meetings.
• Strong expertise in Object Oriented Programming (OOPS) concepts like Encapsulation, Inheritance, Polymorphism and Data Abstraction.
• Good leadership qualities and experience in mentoring junior database developers on complex SQL related development and troubleshooting tasks.
• Excellent analytical, interpersonal and communication skills.
• Expertise in planning, prioritizing tasks based on business requirements.
• Self-learner and pursues training and development opportunities, shares knowledge with others.

TECHNICAL SKILLS

Databases: MS SQL Server (2000, 2005, 2008, 2012, 2014), Oracle, Teradata, Sybase, DB2, MS Access.

Programming Languages: Ab Initio, DELPHI and ASP.NET.

Reporting Tools: Crystal Reports, Fast Reports.

Version Management: Visual Source Safe, TFS

Operating Systems: Windows XP/2K, Windows 7, Windows 8, Windows 10, UNIX, MVS.

PROFESSIONAL EXPERIENCE

Confidential

SQL Server DBA

Responsibilities:

• Installing, configuring, upgrading and managing of SQL Server.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies.
• Implemented SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Trouble shooting and fine-tuning of databases for its performance.
• Verified query plans and gave suggestions for performance improvement.
• Optimized code and improved efficiency in databases including index creation, re-indexing, updating statistics using SQL Profiler. Re-compiling stored Procedures and adding scheduled jobs to re-index and update statistics in databases.
• Deployed new code base release to UAT, DEV and Production Environments.
• Optimized and Automated SQL Server Administration (Configuring SQL Mail, Optimizing SQL Server Agent, Managing Operators, Managing all maintenance Jobs and Deploying DTS Packages and administration).
• Automated Administrative Tasks (Command-Line Utilities and working with DBCC commands)
• Clustering, Replication, Log Shipping and Database Mirroring.
• Diagnosed and tuned the server optimal performance using SQL Server Dynamic Management Views (DMV), SQL Profiler and Index Tuning Wizards.
• Resolved locking and blocking issues.
• Automation of administrative tasks like creating jobs, schedules, alerts using SQL and event notifications using Database Mail
• Extraction, Transformation and Loading (ETL Tools) data using DTS/SSIS Import/Export utility.
• Created ETL Process Consisting of SSIS Packages, Stored procedures and SQL Agent jobs.
• Maintained database response times in 24X7 Production environments, proactively generated performance reports. Automating most of the DBA Tasks and monitoring stats.
• Spreading huge tables to different file groups to achieve maximum performance.
• Query tuning based on High CPU, Memory and Logical reads and writes.
• Supporting Huge Databases, Troubleshooting the problems.

Tools: /Technologies: SQL SERVER (2005, 2008, 2008 R2, 2012)

Confidential

SQL Server Developer

Responsibilities:

• Database designing, creation of numerous database objects like tables, indexes, constrain (Checks, Primary and Foreign Key).
• Creating indexes, Views, complex Stored Procedures, user defined functions, cursors, derived tables, common table expressions (CTEs) and Triggers (DDL & DML) to facilitate efficient data manipulation and data consistency.
• Query analysis, tuning, performance monitoring/troubleshooting using SQL Profiler and DMV's, execution plans review, index coverage and SQL server statistics analysis.
• Working knowledge of XML parsing and interfacing with T-SQL.
• Used TFS (Team Foundation Server) for source code maintenance.
• Done manual testing, Unit testing, Integration testing and System testing.
• Played the role of a mentor in SQL Server to my team mates.
• Helped in recruiting SQL resources for the project and also given KT and guidance in SQL functionalities.
• Worked in Sybase for populating data to Confidential from another application.
• Taken part in the go live activities and involved in document preparation.
• Created System Design Specification document (SDS) for ECP- Confidential integration project.

Tools: /Technologies: SQL SERVER 2008 R2, Windows XP

Confidential

Application Developer

Responsibilities:

• Database designing, creating views and writing SQL queries in Teradata.
• Created graphs in Ab Initio.
• Created complex queries using Inner Join, Outer join in Teradata.
• Developed reports using Teradata advanced techniques like rank, row number.
• Created test cases and did Unit testing, Integration testing and System testing for modules coded.
• Provided technical support to team members and conducted knowledge sessions on project requirements, design and SQL coding standards to the team.
• Create low level design document for the project.

Tools: /Technologies: Ab Initio, Teradata, UNIX

Confidential

DB2 Developer

Responsibilities:

• Created 36 complex DB2 SQL Queries for the creation of Feature vectors in DB2. (Feature Vectors (FV) are composite metrics that are derived from data warehouse fields using ETL codes that have been developed based on client business requirement logics. Feature Vectors can be used as tracking metrics at individual customer level to trend behavior. The main use of Feature Vectors is to develop multidimensional customer clusters and profile for campaign targeting and promoting input optimization.)
• Migrated the ETL codes to two different technologies of Blue stack which are SPSS and SQL-DB2. (The original ETL codes were developed in Speakeasy.)
• Converted ETL codes to DB2 and tested the Output with Speak Easy and SPSS outputs.
• Created technical document for CPO project.
• Used rational Portfolio for managing files in this project.

Tools: /Technologies: DB2, Windows XP