SUMMARY

• Around 9 years of IT experience - high degree of proficiency dealing with RDBMS- MS SQL Server, Teradata and DB2 in the areas of development/DBA.
• Sound knowledge of software development life cycle (SDLC) with substantial experience with object-oriented analysis and design methodologies.
• Possess experience in independently handling design, development, documentation and testing phases in a project environment.
• High degree of proficiency in gathering user specifications from business users and preparing detailed Business Requirement Documents (BRD’s).
• Experience in installation, Configuration, Maintenance and Administration of SQL server 2005/2008/2012.
• Ensure all database servers are backed up in a way that meets the business’s Recovery Point Objectives (RPO)
• Test backups to ensure we can meet the business’ Recovery Time Objectives (RTO)
• Responsible for disaster recovery processes. Well conversant in developing backup and disaster recovery plans for SQL server in Windows Azure Cloud.
• Experience with database availability, clustering, log shipping, and mirroring.
• 24 x 7 Production Database on Call Support.
• Experience in building Data Integration and Workflow Solutions for data warehousing using SQL Server Integration Service (SSIS).
• Experience in creating dynamic and customized packages for ETL from various data sources using SSIS.
• Good knowledge on Teradata SQL, BTEQ, MLOAD & FASTLOAD
• Proficiency in Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimension Table design, Physical and Logical Data Modeling implementations.
• Completed LOMA 280 certification- principals of insurance
• Familiarity on Informatica 9.0.1 and DataStage 8.1 ETL Tools.
• Strong team player with good analytical skills.
• Good Communication skills, with emphasis on strong client relationships.
• Involved in Technical/ process related events. Demonstrated success in coordinating and mentoring development teams.

TECHNICAL SKILLS

Databases: MS SQL Server 2012, SQL Server 2005/2008, Teradata V2R5, Teradata 13, and DB2

Programming: T-SQL, Teradata SQL, C, Java, COBOL, & PL1

DBA: database administration of MS SQL Server 2012, 2008, 2005

Operating System: Windows 2008/2003 Advanced Server, NT & Windows 9x, Linux

Other Software: Windows 2008/2003 Advanced Server, NT & Windows 9x, Linux

Tools: SSIS, SSRS, BTEQ, MLOAD, FASTLOAD, Informatica 9.0.1 and DataStage

PROFESSIONAL EXPERIENCE

Confidential, Boston, MA

MS SQL Server Database Administrator

Responsibilities:

• Responsible for server installation, configurations and Maintenance of SQL Server 2012 in Windows Azure.
• Configured Always on Availability Groups in Windows Azure environment.
• Designed and Implemented comprehensive Backup plans and disaster Recovery strategies.
• Worked on DR strategies and documentation of DR procedures.
• Scheduled Full and Transactional log backups for the user created and system databases in the production environment.
• Setup Database Maintenance Plans to reorganize indexes, re-indexing and update the index statistics on the production databases.
• Developed Different Maintenance Plans such as backups, index management, fragmentation management, cleaning history, deleting old files.
• Created user databases, tables, indexes, and stored procedures.
• Worked on simple to complexSQLQueries and TSQL statements
• Created SQL Server logins and assigning roles and Authentication models as a part of Security.
• Provided 24x7 on call production support.

Confidential, NYC

MS SQL Server Database Administrator

Responsibilities:

• Responsible for the day-to-day administration, technical support, troubleshooting, maintenance, performance and overall health of MS SQL Server 2008 within a Microsoft Windows Server environment.
• Ensure high levels of data availability and reliability of the systems.
• Provided 24x7 on call production support.
• Created Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing
• Scheduled the backups for Databases and Transaction logs. Performed restoration operations. Suggested backup strategies.
• Created new database objects like Tables, Procedures, Functions, Indexes and Views using T-SQL in Development and Production environments.
• Worked on simple to complexSQLQueries and TSQL statements
• Rebuilding the indexes at regular intervals for better performance.
• Involved in Disaster Recovery planning, testing and execution.
• Implemented log shipping as disaster recovery solution.

Confidential, Milwaukee, WI

MS SQL Server Database Administrator

Responsibilities:

• Implemented client's policies, technical procedures and standards for preserving the integrity and security of insurance data, reports and accesses.
• Support for end users connected to servers in various departments with regard to connection and data access issues
• Performed common database administration tasks for Microsoft SQL Server relational database systems
• Creation of user databases, creation of maintenance plans and jobs, user creation and maintenance, database log space monitoring and maintenance
• Developed database objects like Tables, views, stored procedures, indexes etc.
• Write and maintain SQL queries and stored procedures as needed.
• Ensuring that database backups occur in a reliable and regular manner.
• Performed daily tasks including backup and restore by usingSQLServer 2005 tool likeSQLServer Management Studio.
• Monitoring existing maintenance plans.
• Implemented and maintained Database mirroring as a Disaster Recovery Solution.
• Responding to and resolving database access and performance issues. Managing security at all levels of SQL Server.
• Transferring the data (ETL) to Data ware house bySQLServer 2005 Integration Services.
• Created dynamic and customized packages for ETL from various data sources using SSIS.

Confidential, New York

Teradata Database Lead

Responsibilities:

• Lead the execution of the development pipeline and delivery of the code to QA, and ultimately Production
• Ensure that best practices for coding, architecture, and security are employed across the team consistently, and maintain responsibility for the quality development of the applications.
• Provide hands-on development and mentoring as necessary for other members of the development team.
• Designed the order of flow for the execution of the jobs and scheduling the jobs.
• Fine tuning of SQL to optimize the performance, spool space usage and CPU usage.
• Created properPrimary Index (PI)talking into consideration of both planned access of data and even distribution of data across all the available AMPS.
• Worked on concepts involving different types ofIndexes, Joins, and Spacesetc. for optimum performance of Teradata.
• Done Query optimization explain plans, collect statistics
• Primary and Secondary indexes used volatile table and derived queries for breaking up complex queries into simpler queries. Streamlined the Teradata stored procedures.
• Build tables, views,UPI, NUPI, USI and NUSI.
• Worked withDBA’sfor transition from Development to Testing and Testing to Production.
• Responsible for migration and production support.
• Performing Data Validation and Reviewing the code developed
• Status tracking of project activities.
• Onsite - Offshore Co-ordination.

Confidential

Teradata DW/BI Developer

Responsibilities:

• Involved in requirements gathering and data gathering to support developers in handling the design specification.
• Preparing Technical Design Document
• Created, updated and maintained ETL technical documentation.
• PreparedUnit TestSpecification Requirements.
• Extracted data from various source systems like Oracle, SQL Server and flat files as per the requirements.
• Extensive experience in writing and executingBTEQ scriptsfor validation and testing of the sessions, data integrity between source and target database and for report generation.
• Involved in loading of data into Teradata from legacy systems and flat files using complexMLOAD scriptsandFASTLOAD scripts.
• Designed/Developed scripts to move data from the staging tables to the target tables.
• Fine tuning of SQL to optimize the performance, spool space usage and CPU usage.
• Created properPrimary Index (PI)talking into consideration of both planned access of data and even distribution of data across all the available AMPS.
• Familiar with concepts involving different types ofIndexes, Joins, Spacesetc. for optimum performance of Teradata
• Write numerousBTEQ scriptsto run complex queries on theteradata database.
• Created Mappings and scheduled Workflows using Informatica.
• Reduced Teradataspaceused by optimizing tables - adding compression where appropriate and ensuring optimum column definitions.
• Responsible for migration and production support.
• Wrote hundreds of DDL scripts to create tables, views and indexes in the company Data Warehouse.
• Created Global and volatile temporary tables to load large volumes of data into teradata database.
• Performing Data Validation and Reviewing the code developed
• Status tracking of project activities.
• Onsite - Offshore Co-ordination