SUMMARY

• 11 years of IT experience which includes 9 years of system analysis and design, development & support of MS SQL Servers 2008, 2005, 2000, 7.0 and 6.5.
• Extensive working experience in various industries including retail, data management and healthcare.
• Installation and configuration of various services pertaining to SQL Server 2000/2005/2008 such as Database engine, Reporting Services, Integration Services and SQL Agent service.
• Setting up and maintenance of High Availability solution like log shipping, transactional replication and Microsoft clustering services.
• Design and development of logical model and physical database structures involving Normalization techniques.
• Generate and maintain data dictionary and database diagrams.
• Design and developmentof relational model for OLTP Systems and dimensional model (Star Schema) for OLAP (data marts and data warehouses).
• SQL Server Development involving coding stored procedures, User Defined Functions (UDF's), Triggers, Pivot, Unpivot, Table Valued Functions, Cursors, Joins and Xpath queries. (XML)
• Development of complex Reports using SQL Server Reporting Services. (SSRS)
• Design ETL processes and Data migration between different environments using Data Transformation Services (DTS), SQL Server Integration Services (SSIS), BCP and other data transfer techniques.
• Develop and Deploy cubes using SQL Server Analysis Services (SSAS).
• Hands-on working experience with analyzing query plans, using extended Stored Procedures, managing indexes, statistics, locks and troubleshooting deadlocks.
• Hands on experience in Troubleshooting database issues.
• Proficient with database backup and recovery models.
• Server Consolidation effort for lease refreshes. SQL Database Upgrades from 2000 to 2005/2008
• Development of Database Maintenance Scripts using Windows Powershell.

CERTIFICATIONS

MCITP: Database Administrator 2008.
MCTS: SQL Server 2008 Implementation and Maintenance.
MCDBA: SQL Server 2000

Technical Skills:
Databases: SQLServer2008/2005/2000/7.0/6.5,Oracle9i/10g, MS Access.

Client Server: Visual Basic 6.0/5.0, PERL, VC++, C/C++, SQL Servers, Transact SQL, HTML and Crystal Reports 7.0, VB.Net, SQL Server Reporting Services

Operating Systems: Windows2008/2003/2000/XP/Vista/NT4.0/98/95, UNIX, DOS 6.22.

Tools: SQL Server Enterprise Manager, SQL Server Management Studio (SSMS), Query Analyzer, SQL Profiler, Perfmon, Surface Area Configuration Tool, Team Foundation Server (TFS),VSS, Business Intelligence Developer (BIDS), Visio, Power Designer, Maestro, Expert Advisor, Tivoli Change Management, PVCS Version Control, PVCS Tracker, Peregrine Service Center , SQL Server Migration Assistant for Oracle (SSMA), Informatica PowerCenter 8.1, Visio, Erwin.

PROFESSIONAL EXPERIENCE

Confidential, Richardson, TX Jan 2011 - Current
SQL Server DBA /Client Services DBA team

• Install and configure SQL Server standalone and clustered instances.
• Perform Active/Active and Active/Passive cluster configuration set up for Microsoft SQL Server 2005/2008/2008R2.
• Set up and test Disaster Recovery procedures for SQL server databases.
• Migration of SQL Server databases from old to new server hardware infrastructure.
• Work with the application development teams, focusing on the back-end portion of data storage considerations and performance considerations for application systems being developed.
• Microsoft SQL server security set up and Perform periodic Audit SQL Server instances.
• SQL programming, writing stored procs and data modeling.
• Implement Extract, Transform and Load procedures using SQL server Integration Services (SSIS).
• Performance tune existing Stored Procs and SQLs.
• Maintain versions and syncup different Database environments.

Confidential, Dallas, TX May 2010 - Dec 2010
Systems Engineer II - DBA / DBA Support Services

• Perform Database Administration including installation, configuration, maintenance, and troubleshooting of SQL databases on standalone and Clustered environments.
• SQL Server 2008 SP1 Slipstream installation on Windows 2008 R2.
• Set up High Availability features like Clustering, Log Shipping, Database Snapshots, Transactional and Merge Replication.
• Design and implement database security controls. Use proper auditing procedures to maintain integrity of enterprise database systems.
• Review and implement database-related changes following established change management and release management procedures.
• Perform database system capacity planning and capacity monitoring.
• Calculate optimum values for database systems such as amount of server memory, number of processors, layout of physical disks and database file layouts on disk for instances hosted on both physical and virtual hardware.
• Review database schema, objects and data scripts written by others and provide feedback.
• Manage the creation and versioning of SQL-based code using approved source control tools through the software development lifecycle procedures.
• Develop and test database maintenance scripts using Windows Powershell.
• Create, deploy and support SSIS packages.
• Proficient in SSIS package development and troubleshooting.
• Virtualization of SQL servers (VMware).
• Setup and support SSRS Report development experience.

Confidential, Denton, TX, Mar 2010 - May 2010
MS SQL Server DBA / POS NG (Point of Sale, New Generation)

• Set up Peer to Peer Transactional Replication using SQL Server 2008.
• Performed Database Backup/Recovery.
• Worked on migrating SQL Server database systems across servers.
• Worked on Extract, Transform and Load (ETL) using SQL Server Integration Services (SSIS).
• Architected Dynamic Configuration of the ETL packages using XML Config File, SQL Server Config Table and environment variable. This enabled SSIS package deployment across environments without making changes to the packages.
• Worked on performance tuning SQL Queries.
• Environment: SQL server 2008, Business Intelligence Development Studio (BIDS), SSIS, VSS, Asp.Net, Net Framework 3.0.

Confidential, Sacramento, CAJul 2009 - Feb 2010
Sr. MS SQL Server Developer - SIERA (System for Integrated Electronic Reporting and Auditing)

• Analyzed business requirements and build logical data models that describe all the entities and relationships between them. Implemented Physical database structures based on the logical model developed.
• Developed new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in SQL Server 2005 and SQL Server 2008.
• Translated business requirements to technical solutions.
• Worked on prototypes and development of new data products for data consumers.
• Developed Complex Reports using SQL Server Reporting Services (SSRS).
• Developed and deployed ETL packages using SQL Server Integration Services (SSIS).
• Assisted with various ad hoc query requests.
• Provided back-end support for functional testing and performance testing.
• Followed Software Development Lifecycle (SDLC) as it pertained to database administration and development.
• Managed SQL Server Logins, users, roles, schema and permissions.
• Created data-related documentation (e.g., data dictionary, entity relationships and diagrams, etc.)
• Worked on Change Requests and bug resolution.
• Utilized Team Foundation Server (TFS) for Version Controlling of Backend code/Scripts.
• Performed periodic database backups and refresh other environments using the backups performed.
• Performance tuning involving query analysis, index tuning, fragmentation analysis.
• Fixed database corruption issues.

Confidential, San Francisco, CAFeb 2009 - Jun 2009
Member of Backend Team (MS SQL Server Developer/DBA) - Planet Wholesale (PWO)

• Performance tuning of long running queries/stored procedures.
• Encryption of column level data using SQL Server encryption certificates and keys.
• Supported ETL processes scheduled as DTS and SSIS packages in the PWO environment.
• Worked on Data Quality Engine (DQE) issues to resolve data anomalies.
• Worked on Wachovia internal user migration from HR and Active Directory to PWO environment, enabling Wachovia internal users to access PWO Application.
• Managed security access requests (user creation/permissions and setting up db roles).
• Responded to Adhoc user requests.
• Worked on back end related Change Requests and Bugs.
• Environment: SQL Server 2000/2005, Business Intelligence Development Studio (BIDS), Visual Source Safe.

Confidential, Sacramento, CA Jul 2007 - Jan 2009
Sr. MS SQL Server Developer - Annual Financial Data Model and Data Conversion

• Analyzed business requirements and build logical data models that describe all the entities and relationships between them. Implemented Physical database structures based on the logical model developed.
• Created data-related documentation (e.g., data dictionary, entity relationships and diagrams, etc.)
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in SQL Server 2005 and SQL Server 2008.
• Developed ETL process to convert existing mainframe DB2 data to the newly designed SQL Server 2005 relational data base. (using SQL 2005 SSIS packages)
• Worked on prototypes and development of new data products for data consumers.
• Assisted with various ad hoc query requests.
• Provided back-end support for functional testing and performance testing.
• Developed Complex Reports using SQL Server Reporting Services.
• Managed data access to Oracle from SQL Server using SQL Server linked servers.
• Followed Software Development Lifecycle (SDLC) as it pertains to database administration and development.
• Developed cubes using SSAS with fact and dimensional tables in the Oracle Data warehouse as the source.
• Performed periodic database backups and restores.

Confidential, Pittsburgh, PA, Jul 2006 - Jun 2007
MS SQL Server DBA/ SQL Server Developer

• Conversion of Oracle Packages (Pl/SQL) to SQL SERVER (T-SQL) procedures and functions.
• Designed database objects, tune queries, and be a major contributor to the overall database architecture. Made significant enhancements to base application and provide customized client specific solutions.
• Research, design and documentation of custom solutions for client requests.
• Assisted in development of test scripts, product builds and installation programs.
• Designed and developed procedure based Extract, Transform (ETL) and Load process to consolidate data from heterogeneous source systems. (using SSIS)
• Performed periodic database backups and restores. Manage security for SQL SERVER.
• Created and managed data dictionary and Entity Relationship diagrams for SQL Server databases.
• Development of logical and physical database designs.
• Set up and configured database mail to send automatic email messages.

Confidential, Napa, CA, Mar 2006 - Jun 2006
MS SQL Server DBA/SQL Server Developer

• Developed ETL process using DTS packages and scheduling them.
• Developed reports based on business user's requirements using SQL Server reporting services and deploy them.
• Troubleshooting issues with SQL Server jobs, DTS packages and reports.
• Performing restore of databases per the requests from the clients.
• Scheduling nightly jobs in the SQL Server Agent to carry out the database maintenance activities such as database backups and consistency checks.
• Scripting: TSQL and Batch scripting to carry out the daily activities such as triggering jobs, automating processes and mass deployment of changes across the various SQL Servers.
• Handling daily user requests in regards to providing access permissions on objects and creation of logins.
• Assisting in database migration activities and databases refreshes.

• Migration of database to different SQL environments, upgrading versions of SQL Servers, moving SQL Systems across different storage systems such as MSA 1000 and SAN systems.
• Designing, testing and implementation of Perl scripts for carrying out the various database maintenance activities.
• Performance tuning and optimization of the various SQL Server environments.
• Disaster recovery of SQL Servers meeting the Service level agreements for the various customers
• Setting up log-shipping and SQL replication across critical systems which need high availability and faster point in time recoverability
• Capacity planning of the SQL database systems.
• Functioning both as an Application and Infrastructure DBA and performing the activities that accompany each of the above responsibilities.
• Providing 24x7 technical database support for the 1000 plus SQL Database systems.
• Refreshing data from production to the lower environments on request.
• Data migration between different environments/linked servers using DTS (Data Transformation Services) and other data transfer techniques.
• Periodic Auditing of SQL Servers, so as to ensure compliance to the Best Buy standards.

Environment : SQL Server 2005,2000, 7.0 and 6.5, Perl, Power Designer, SQL Server Reporting Services, TSQL, VSS, PVCS, Maestro, Expert Advisor, Windows NT, Windows 2000/2003.

Confidential, Minneapolis, MN, Jul 2002 - Jul 2003
Member of the SQL Database Support Services team

• Capacity planning, Maintenance activities pertaining to database like backup restore, setting up SQL server security.
• Setting up and maintenance of High Availability solution like log shipping, transactional replication and Microsoft clustering services using Windows 2K Advanced and Microsoft SQL Server 2000 Enterprise edition.
• Fixing database corruption issues, Periodic re-indexing to improve the performance and database sizing.
• Update the site with the latest Tax Rates monthly.
• Review and approve any changes made to the site that involves stored procedures, Schema changes and replication.
• Maintaining different database environments like Development, Quality and Preproduction and Production.
• Generating ad hoc reports, running adhoc queries, which require system administration security.

Confidential, IndiaFeb 2001 - Jun 2002
SQL Server Database Programmer and Administrator

• Installation of SQL server 7.0. Responsible for doing the schema changes to the database and the regular database maintenance activities including backup and recovery.
• Setting up of logins, users, roles and granting permissions to them.
• Index tuning and tuning of sql queries.
• Developed Stored Procedures in SQL Server 7.0 for the reports.
• Developed new reports requested by the client using Crystal Report writer 4.6
• Prepared the Installation Kit (Product Packaging) using package and deployment wizard and tested the same in different platforms.
• Developing Windows Help for applications using RoboHelp 5.0.
• Implementation support to BHEL(Bharat Heavy Electricals Limited).

Confidential, India Jun 2000 - Jan 2001
Analyst Programmer Trainee

• Driver Software development for modicon PLC's using MODBUS Protocol. Driver reads data from External System (modicon Programmable Registers) via Com port using Windows API Functions. Coding using C and C++
• Testing and fixing of bugs reported.

Environment: C, C++ and VC++, Visual Source Safe, Crystal Reports 4.6, Robohelp, Windows NT 4.0 Servers/ Workstations.

EDUCATION
Bachelor of Technology (B.Tech) in Electronics and Communication Engineering, India