SUMMARY:

• 10 years of professional experience as Database architect, Administrator/Developer related to Financial, Mortgage, Health care and Manufacturing databases on SQL Server 2008 R2 / 2005 / 2000 / 7.0,Greenplum 3.3.4/4.1,Oracle 10g, PostgreSQL 9.0/9.1
• Expertise and Interest include Administration, Database Design, Performance Analysis, and Production Support for Large VLDB and Complex Databases.
• Having good expertise in data modeling a metadata services.
• Specific hands on experience include administering large and complex Databases, Database Design, Normalization, Replication, Log Shipping, Full text indexing, and Database Application Development using varied development tools.
• Extensively worked on ETL design and development.
• Expert in dimension modeling OLAP structures.
• Performance Tuning Application Design.
• Hot and Cold Backups, Disaster Recovery Planning, Security Management, Managing server and clients, T-SQL/PL/SQL/SQL Lexicon, Stored Procedures, Functions and Cursors and Triggers etc.
• Handling Memory configurations for database servers.
• Implemented the new SQL Server 2005 concepts like Data partitioning ,Snap shot isolation, database mirroring, database snapshot, DDL triggers, try-cache blocks, online indexing, DMV's, DMF's, Mail Setup, Jobs, and Alerts, DTA,SQLCMD and dedicated admin connection.
• Expertise in writing complex MDX, DMX and XMLA queries.
• Extensively worked on 32 bit and 64 bit clustered and standalone server environments.
• Data modeling Experience like Physical data modeling and logical by using ERWIN.
• Worked on Replication and Log shipping for SQL Server High Availability
• Extensively worked on Active-Active and Active-Passive Clustering
• Having hands on experience in Database Mirroring.
• Expert in data loading services like SSIS, DTS, BCP Bulk Insert and gpdist,gpload and copy commands.
• Having Experience working on Data center servers and handling >1.4 TB databases.
• Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support.
• Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery planning and Security Management.
• Troubleshoot performance problems, fine-tuning of databases and index Analysis.
• Monitoring tools and Application support.
• Experience in Oracle Database 9i/10g Administration.
• Created PL/SQL packages, procedures and functions.
• Having good experience in integrating ERP systems with MS Sql server and also can understand working code of ERP systems such as SAP-ABAP etc.
• Having good experience in configuring and troubleshooting IIS and XML.
• 24 X 7 Production Database on Call Support

TECHNICAL SKILLS

Project Domain: Application Development, Systems Integration and Database Administration of MSSQL Server 2005/2000/7.0/6.5, PostgreSQL 9.0/9.1

Languages: Java, Visual Basic 6/5, ASP.NET, C, C , C , XML, HTML

Database: SQL Server 2005,2000/7.0/6.5, Greenplum 3.3.4/4.2, PostgreSQL 9.0/9.1, DB2 8x UDB, Access and Sybase

Tools: Active X, IIS, SSIS, DTS, MTS, litespeed, Spotlight.

ETL Tools: Informatica 7.1.2/6.1.X.

Business Intelligence: Crystal Reports XI/10/9, Business Objects XI/6.5.1.

Operating System: Windows 2003/2000 Advanced Server, UNIX,Linux, NT Windows 9x.

Other: Microsoft Office word, excel, power point, outlook , MS Visio, Visual Studio 2005, 2003.

PROFESSIONAL EXPERIENCE:

Confidential

Sr Greenplum/PostgreSQL Consultant

• Database Administrator, Database Programming.
• Closely worked with SME to understand requirements.
• Reverse engineered data models to improve Green plum function queries.
• Worked on changing distribution keys to avoid data skew and improve performance.
• Worked on end to end application level performance tuning re designing data models ,choosing proper distribution keys re write greenplum function code.
• Extensively worked on ELT performance tuning using multiple Gpfdist instances and available hardware
• Worked on Greenplum features, benefits, and understanding architecture in terms of shared
• nothing and the MPP design and how Greenplum supports redundancy and high availability
• Install, initialize, validate, and configure Greenplum Databases.
• Manage database objects and workload management processes by defining and managing roles, privileges, and resource queues.
• Implemented Greenplum's Advanced workload management for dynamic query prioritization.
• Designed and implemented table partitioning for handling very large tables.
• Load data into a Greenplum database instance using external tables, SQL copy and insert commands, and parallel load utilities.
• Extensively used gpfdist and gpload utilities for data load and unload.
• Extensively used data manipulation language and data query language to access, manage,
• and query data.
• Perform system administrative tasks, managing and checking the state of the Greenplum databases and its distribution of data.
• Used EXPLAIN and EXPLAIN ANALYZE to identify and fine tune sql queries for performance improvements.
• Worked on Improving query performance by keeping statistics up to date and tuning the database for sampling size and error conditions.
• Planned and implemented disaster recovery of greenplum databases using EMC data domain
• Perform backup and restoration of Greenplum databases using gp crondump,gp backup,gp restore utilities on EMC Data Domain.
• Improve query performance by following performance enhancement tips and database best practices.
• Expert in writing complex SQL scripts.
• Expert in writing shell scripts.

Confidential

LEAD Greenplum/Postgre SQL DBA/Developer

• Database Administrator, Database Programming.
• Played a key role in data modeling datawarehouse for reporting needs.
• Install, initialize, validate, and configure Greenplum Databases
• Manage database objects and workload management processes by defining and managing roles, privileges, and resource queues
• Designed and implemented table partitioning for handling large tables
• Load data into a Greenplum database instance using external tables, SQL copy and insert commands, and parallel load utilities.
• Extensively used data manipulation language and data query language to access, manage,
• and query data.
• Perform system administrative tasks, including managing and checking the
• state of the Greenplum database and its data and checking the distribution of data.
• Used EXPLAIN and EXPLAIN ANALYZE to identify and fine tune sql queries for performance improvements.
• Worked on Improving query performance by keeping statistics up to date and tuning the database for sampling size and error conditions.
• Perform backup and restoration of Greenplum databases
• Distribute and store data in Greenplum using a distribution key and partitioning
• Worked on optimizing indexes for better performance and maintainability
• Improve query performance by following performance enhancement tips and database best practices.

Confidential

LEAD DBA/Developer

• Worked closely with end-users to Define Requirements, Resolve Issues, Troubleshoot problems and Provide Solutions for various applications and day to day business needs.
• Actively involved in Data Modeling a new star-schema based database from legacy flat tables to improve performance, redundancy and scalability.
• Designed and Developed mortgage models, pricing models, tax reporting models.
• Wrote complex stored procedures, triggers, functions and T-SQL.
• Tuned stored procedures for performance improvement.
• Daily administration and tuning of SQL Server 2005 and 2008 R2 servers
• Designed, developed and implemented Databases from scratch.
• Involved in logical and physical data modeling.
• Suggested and configured High availability solutions like Database Mirroring, Clustering and log shipping.
• Designed, Created and Implemented complex SSIS packages for data warehouse
• Good knowledge in Mortgage data analysis and elements.
• Planned and Configured Team Foundation Server TFS for maintaining source code and version control.
• Created Release Process Documentation to establish a staged migration method from the Development to the Production environment.
• Release deployment Lead responsible for mentoring other developers and ensuring best practice for coding and deployment were followed.
• Responsible management of offshore DBA and developers.
• Designed, Developed and Tested automation of Tax Reporting.
• Worked on Oracle OBIEE for designing, building complex reports.
• Responsible for performing a Proof of Concept using Microsoft Windows AZURE to demonstrate cloud technology to the client.
• Have good experience with SSIS, SSRS
• Extensive use of Red-Gate SQL Server and Developer Tools

Confidential

SQL Server DBA/Developer

• Closely worked with business users in gathering requirements to provide key data for critical business decisions.
• Developed logical design and physical design
• Administered and maintained Production/Development servers with more than 2 TB of database size with complex structures.
• Designed a report on the monitoring of SQL Server Performance. This report gives a detail report to the management on the Performance of the server.
• Worked with SQL server Profiler to generate traces to find long running stored procedures and queries to tune for peak performance
• Integrated SQL server profiler traces with Performance monitor to have better graphical analysis to find system bottlenecks.
• Expertise in Fine tuning complex queries
• Expertise in setting up and troubleshooting Database mirroring.
• Optimized working process.
• Rebuilding the indexes at regular intervals for better performance
• Extensively working on IMS performance issues like update statistics, rebuilding the indexes at regular intervals for better performance.
• Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks.
• Configured up to 32 GB of memory.
• Was responsible to develop customize reports requested by clients.
• Deploy/Design cubes in SSAS environment Snowflake/ and Star Schema designs.
• Generated reports by using Repots using SSRS.
• Redesign/ Deploy reports using Report Services 2008.
• Used Reporting Services SSRS to schedule reports to be generated on predetermined time.
• Created report models for Report Builder and managed reports using Report Manager.
• Created ad-hoc queries from SQL Server databases for custom reporting needs.
• Created sub reports, cross tabs, charts, ad-hoc reports using SSRS.
• Tuned servers to the peak for maximum performance by configuring memory and various server level parameters.
• Involved in developing C , C code as a part of various transition projects.
• Hands of experience in writing batch files.
• Extensively worked on extraction, transformation and loading of data from various data sources to SQL Server using SSIS.

Confidential

SQL server 2005 DBA/Developer

• Worked on Client/Server tools like SQL Server Management studio 2005 , SQL Server Enterprise Manager 2000 and Query Analyzer to Administer SQL Server.
• Worked closely with ERP SAP development team in integrating SQL Databases and troubleshooting issues as and when needed dynamically.
• Handled up to 2 TB Size databases with clustered and replication environment
• Wrote the packages using SSIS in SQL2005.
• Configured more than 2 GB ram on 32 bit Environment.
• Worked in Active passive cluster environment.
• Used log shipping for synchronization of databases.
• Prepared Documentation for the Disaster Recovery plan
• Implemented new topics like CLR integration on Development Server.
• Wrote and debugged Stored Procedures and DDL /DML Triggers , Functions as per client requirements
• Extensively worked on Dynamic Management Views DMV's .
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Planned and modified the permission issues in the server.
• Maintaining SQL Script for creation of Database Objects using VSS Visual Source Safe .
• Used APPLY clause and also implemented with CROSS and OUTER APPLY to join tables and table variable functions
• Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks.
• Update Database Statistics and Re-indexing.
• Planned the Complete Backing up of Database and Restoring the Database from Disaster Recovery.
• Used the Litespeed to take backups.
• Used DTS packages to move logins and jobs from one server to another server.
• Used log shipping for synchronization of database.
• Good experience in data modeling and metadata services.
• Monitoring SQL server performance using profiler to find performance and dead locks.

Confidential

SQL Server 2005 DBA /Developer with SSIS Data Warehouse

• Perform business analysis, technical analysis, systems design, application development
• Prepared DFD's Entity Relationship ER diagrams.
• Restructuring the stored procedure ,designing, coding and developing the same using the SQL
• Server Integration services SSIS .
• Developed and deployed packages using SSIS IN SQL2005
• Transferring the data ETL to Data ware house by SSIS.
• Extensively worked on Dynamic Management Views in SQL Server 2005
• Authored, and managed reports using SQL Server 2005 Reporting Services
• Extensively working on IMS performance issues like update statistics, rebuilding the indexes at regular intervals for better performance.
• Extensively worked on compliance issues.
• Export or Import data from other data sources like flat files using Import/Export from Bloomberg.
• Created SSIS / DTS packages to pull data from Oracle and Flat Files.
• Using SSIS, Experience in data transformation domain.
• To analyze long running slow queries and tune the same to optimize application and system performance.
• To set up SQL Server configuration settings.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Rebuilding the indexes at regular intervals for better performance
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Expertise and Interest include Administration, Database Design, Performance Analysis, and Production Support for Large VLDB and Complex Databases up to 2 Terabytes.
• Rebuilding the indexes at regular intervals for better performance
• Created stored procedures for maintaining SQL Server, Written Stored Procedures for Application Developers.
• Experience in writing and reviewing T-sql code, maintaining coding standards across the board in all SQL Server environments
• Used Performance monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Created indexes to speed the execution of data retrieval queries and stored procedures.
• Maintaining the database consistency with DBCC at regular intervals

Confidential

SQL Server DBA

• Database Administrator, Database Programming.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of User Support.
• Maintaining the database consistency with DBCC at regular intervals
• Monitoring SQL server performance using profiler to find performance and dead locks.
• Managed Disk space, memory and User connections.
• Performed Database Integrity Checks, updated Database Statistics and performed Re-indexing.
• Database Development, Database Programming.
• Created and managed schema objects such as tables, views, clusters, indexes, procedures, and triggers and maintained Referential Integrity.
• Generated Script files of the databases whenever changes are made to stored procedures or views.
• Rebuilding the indexes at regular intervals for better performance
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
• Monitored and modified Performance using execution plans and Index tuning.
• Rebuilding the indexes at regular intervals for better performance
• Managing the VERITAS net backups.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency
• Complete documentation about the database
• Monitoring SQL server performance using profiler to find performance and dead locks and blockings.
• Monitoring the servers using idera third party software.
• Export or Import data from other data sources like flat files using Import/Export through DTS, SSIS.
• Converting DTS packages into SSIS.
• Recovering the databases from backup in disasters
• To analyze long running slow queries and tune the same to optimize application and system performance.
• To set up SQL Server configuration settings.
• Extensively Involved in writing PL/SQL procedures, functions, triggers packages, Java Procedures and then Multi-threading them through Unix Shell Script.
• Worked on PL/SQL Packages, Procedures, Objects, VARRAYS, Functions, and REF Cursors for data analysis.
• Wrote ad-hoc SQL and triggers.
• Migrated data from the flat file to database using SQL Loader.
• Worked on User Creations, Roles, Security and Granting Privileges in Oracle.
• Creation of E-R diagram, OFDs Object Flow diagram as per user requirement.
• Designing Tables, Constraints, Views, and Indexes etc. in coordination with the application development team.