SUMMARY

• A Confidential Certified Professional with over 7 years of IT experience in which includes more than 5.2 years of experience in databaseAdministration andDevelopment.
• Extensive experience in Design, Development, Implementation & Administration of Client - Server Applications & Database systems using MSSQL 2000/2005/2008/2008 R2for both OLTP&Data warehousing applications.
• Expert skills on SQL Server Installation, Configuration, Backup/Restores, Security Administration, Performance Monitoring, Replication, Database mirroring &Clustering.
• Involved in IIS administration managing IIS Servers.
• Involved in Development, Deployment and Prod Support of SSIS packages across various environments.
• Migration of SSIS Packages between different servers and Command line SSIS Package support using DTSEexec and SQLAgent jobs.
• Experience in database programming in writing T-SQL Stored procedures, Triggers, Constraints and Indexes using various DDL and DML commands.
• Involved in Security Administration, Managing schemas (2005/2008), and creation of users, configuring permissions and assigning roles to users.
• Administered, maintained, developed and implemented policies and procedures for ensuring the security and integrity of the company databases.
• Involved in Huge data migrations, transfers using utilities like Data Transformation Services (DTS), SSIS, Bulk Copy Program (BCP) and Bulk Insert.
• Experience in Database Backup, Recovery andDisaster Recovery procedures (including DR/Standby servers) using various 3rd party tools like Netapp, VERITAS, SQLLitespeed, BMC SQLBacktrack.
• Hands on experience in trouble shooting database issues, Transaction Log Issues, Capacity Planning & Space issues.
• Monitoring Daily Jobs, DB Maintenance Plans, and Run DBCC jobs for Reindexing, CheckDB, Fragmentation etc.
• Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.
• Experience in Reporting Services (SSRS)and Integration Services (SSIS).
• Worked closely with management, applications development staff, and users on database solutions to business problems.
• Defined and administered database standards, controls, procedures and documented the same.
• Experience in implementing different types of Replication models liketransactional, Snapshot.
• Involved in Server & DBMonitoring and tuning efforts using various tools like Perfmon, SQLServer profiler, IndexTuningWizard (ITW),Database Tuning Advisor, SPOTLIGHT
• Having Experience on Data center servers and handling VLDB over 2 TB databases.
• Provided after hours and 24/7 production maintenanceand support.
• Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.

TECHNICAL SKILLS

Languages: T-SQL, SQL, PL/SQL,C#, PERL,PHP, Shell Scripting, VB Script.

RDBMS: SQL Server 2008 R 2/2005/2000/7.0 , Oracle 10g, DB2,PostgreSQL, MS Access 2010Tools VSS 2005/6.0, Erwin 5.1, DBArtisan, RapidSQL, Spotlight, Netapp Snap manager,SQLBacktrack,Autosys,Control-M,IBM TSM

OS: Windows 2008/2003Advanced Server, Unix, Redhat Linux, Windows

Reporting Tools: Seagate Crystal Reports 7.0/8.0, SSRS.

SQL Server Tools: Enterprise Manager, OEM, Profiler, Query Analyzer, Export & Import.

BI Tools: SSIS, SSRS BIDS.VisualStudio2008

Change Control: Tortoise SVN, Remedy Help Desk, Visual Studio

PROFESSIONAL EXPERIENCE

Confidential, Irving, TX

SQL Server DBA

Responsibilities:

• Involved in Installation, configuring, administration and troubleshooting multiple databases in development, QA, Production and DR environments
• Migration&Upgradation of SQL Server 2005 to SQL Server 2008/2012 across various SDLC environments like Testing, Development and Production Environments.
• Efficiently handled production environments with more than 100 servers, Databases ranging 300 GB - 3.5 TB for various applications
• Installation of hot fixes, service packs and Patches both in clustered and stand alone environments
• Worked on multi node Active/Active Clustered Environments.
• Involved in Data Modeling and Designing databases for OLTP and Data warehouse systems.
• Implemented and maintained database security by creating users, roles and assigning privileges.
• Involved in devising backup and recovery processes and procedures using Native and 3RD party backup tools like SQLLitespeed, NETAPP and various schedulers
• Created jobs, alerts, activity logs, error logs to debug any possible errors.
• Experience migrating SQL Server 2000 DTS packages to SQL Server 2005/2008 SSIS packages and installation of feature packs.
• Involved in Development, Deployment and Prod Support of SSIS packages across various environments.
• Install & Configured of transactional replication between Primary Server and Report Server and troubleshooting for Replication Issues.
• Monitored performance by using SQL Profiler, DMFs, DMV'sand benchmarked performance metrics.
• Worked extensively in Performance tuning, optimization of stored procedures and queries.
• Successfully implemented Database Mirroring with High Availability Mode in MS SQL Server 2005and MSSQL Server 2008.
• Creating partition tables according to the requirement and business logic.
• Played major role in defining the SQL Standards to maintain code consistency.
• Created reports using MS reporting services to generate reports for SQL safe backup and restore details.
• Created Database Maintenance Plans for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Performed Structural changes to Database like creating tables, adding columns, creating indexes according to business requirement.
• Rebuilt indexes on tables using various SQL Server commands to reduce fragmentation.
• Involved in Code Reviews and adhered to SOX (Sarbanes-Oxley) change control policies and procedures.
• Worked with developers and end users along with PMO offices in both Agile Scrum project methodologies

Environment: MS Windows 2008/2003 Server, MS SQL Server 2008R 2/2005/2000/2012 , Oracle 10g,PostgreSQL 9.1, IBM e series Servers, BIDS, DBA artisan, Rapid SQL, OEM, Storage Area Network (SAN), Netapp Snap manager, Unix, Redhat Linux, Veritas.

Confidential, Seattle WA

SQL Server DBA/SSIS

Responsibilities:

• Developed logical and physical data models to support specific needs as requested by the application users and development teams.
• Performed Migration of Servers from SQL Server 2000/ R2
• Installation of service packs, Testing of Hotfixes and security patches.
• Responsibilities included attending Team Meetings database analysis and design as well as data mapping for a conversion from a legacy flat file database to a relational database.
• Creating and managing schema objects such as Tables, Views, Clusters, Indexes, Procedures, and Triggers and maintained Referential Integrity.
• Security Administration: Included creating various user groups and assigning the accessibility according to requirement, monitoring the user accounts, creating user accounts, granting the privileges to users and groups.
• Monitoring all activities of the Server by monitoring the daily SQL jobs, SQL Server error logs and Windows error logs.
• Used IIS FTP Utilities for file transfers between servers.
• Worked on data access layer using ASP.Net, ADO.Net and C#.
• Design Modifications done to the application data model using Confidential Visio.
• Done Database refreshes from production to development/Test environments periodically
• Designing and optimizing all the SSIS packages.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases.
• Create backup and maintenance jobs using SQLServer Agent and SQLLitespeed for compressedBackups.
• Develop and deliver dynamic reporting solutions using SQL Server 2005 Reporting Services (SSRS).
• Created Visio flowcharts, technical documents, etc. as necessary.
• Various types of reports (Drill down, Matrix, and Navigating) with charts were created using SQL Reporting Services 2005 (SSRS), Crystal Reports.
• Implemented Confidential Reporting Services toprovide critical reports forsenior management as well as reporting for partners.
• Resolved database performance capacity, replication and other distributed data issues.
• Responsible for 24X7 on-call rotation.
• Supported offshore and onsite teams on day to day activities.

Environment: MSSQLServer2008R2/2005/2000, Oracle10g/9i, BIDS, TOAD for Oracle, IIS 6.0, OEM, Storage Area Network (SAN), Quest Lite speed, IBM TSM, Autosys, Perfmon, Dashboard.

Confidential, Louisville, KY

SQL Server DBA/SSIS

Responsibilities:

• Installed SQL Server 2005/2008 with Service packs in all environments.
• Involved with upgrading from SQL Server 2000 to SQL Server 2005/2008 on Development, Testing Production Environments.
• Provided assistance and mentoring staff for developing conceptual, logical and physical database designs.
• Involved in migration of data from Legacy Systems including Access and IBM to SQL Server.
• Successfully implemented Database Mirroring with High Availability Mode in SQL 2005.
• Implemented Log Shipping from Primary Server to Standby Server to support DR Solution.
• Involved in migrating DTS packages from SQL Server 2000 to SSIS packages in SQL Server 2005 database using migration wizard.
• Created SSIS packages for the archive and purge process from all the production servers.
• Experience in resolving blocking and dead lock Issues by using SQL commands.
• Experience writing queries in PL/SQL using Oracle 10g.
• Extensively worked in Performance tuning, optimization of stored procedures and queries.
• Rebuilt indexes on tables using various SQL Server commands to reduce fragmentation.
• Monitored Performance with SQL Profiler and using a monitoring tool called Quest Spotlight.
• Involved in IIS administration managing IIS Servers.
• Used IIS FTP Utilities for file transfers between servers.
• Used Quest Lite speed as Backup/Restore tool.
• Creating Logins and Roles with appropriate permissions.
• Providing support to developers in Performance Tuning and Query Designing.
• Prepared high level and detail database design documents for development modules.
• Designing and implementing Backup/Restore Strategies for the SQL database.
• Helped development team to audit Front - end application calls to SQL Server to create efficient Queries, Indexes, Views and Stored procedure.
• Configured client workstation with client operating system and permissions for users and user groups.
• Monitored activity logs and system activity.

Environment: MS Windows 2003/2000 Server, MS SQL Server 2008/2005/2000 , IIS 5.0, Oracle 10g, IBM e series Servers, Dell 6500 quad processors with 16 GB RAM, Quest Lite Speed, Quest Capacity Manager,Redhat Linux

Confidential, NY/NJ

SQL Server DBA/SSIS

Responsibilities:

• Managed and Administered SQL Server 2008/2005/2000 production and Non-production servers for corporate divisions
• Assisted Windows Admin in order to determine editions, service packs on Windows Server 2003/2008 to configure custom High Availability Solution and Disaster Recovery Strategy.
• Installation of SQL Server 2008/2005 on Windows Server Clustered environment.
• Worked on Conceptual, Logical, Physical data modeling and Performance Analysis.
• Performed backup using backup compression, recovery procedures and disaster recovery plans.
• Handled up to 800 GB Size databases in both clustered and stand-alone environment.
• Used SQL Server Surface Area Configuration to configure server level and instance level settings.
• Capacity planning and application support for front end feeds and Resolved Application connectivity issues like connection timeouts, connection pooling issues and memory leaks.
• Setting up and monitoring replication, Database mirroring and Log shipping on Production, and Test servers.
• Expert in SQL Server 2008 new features like Policy Based Management, Data Compression, Resource Governor, Performance Data Collector, Transparent Data Encryption (TDE), Object Search, IntelliSense, Activity monitor and Multi Server Query.
• Upgraded SQL Server 2005/2000 databases to SQL Server 2008/2005 databases including DTS to SSIS packages.
• Involved in IIS administration managing IIS Servers.
• Used IIS FTP Utilities for file transfers between servers.
• Created, scheduled database maintenance plan using SSIS Maintenance plan task.
• Configured and deployed SSIS Packages from Test to Production Environments.
• Created, deployed and managed reports using SQL Server Reporting Services (SSRS).
• Extensively worked on Profiler, Performance Monitor, dynamic management views (DMV), dynamic management functions (DMF) and database tuning advisor (DTA) to tune the databases, servers and query tuning.
• Created/altered/modified and tuned T-SQL Stored Procedures, Complex Queries, indexes, views, tables, re-indexing, structure modifications and functions.
• Reviewed stored procedures developed by the developers and gave recommendations for the code modifications for production.
• Optimizing performance of individual queries at the lowest granularity level by analyzing Execution Plans and estimating their cost of execution.
• Used Performance Monitor to Help Identify SQL Server Hardware Bottlenecks.

Environment: SQL Server 2008/2005/2000 , DTS, BCP, Crystal Reports, IIS 4.0, MS Reporting Services, SSIS, Performance Tuning, Clustering, Bulk Insert, HTML, DHTML, PL\SQL, Windows 2000 Platform.

Confidential

SQL Server DBA

Responsibilities:

• Created Database Maintenance Plans 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 for Disaster Recovery.
• Creating back up strategies and scheduling them for execution.
• Performance Monitoring using SQL Profiler, Windows System Monitor, System Stored Procedures, and DBCC Commands.
• Monitored SQL server LOGS, Application logs and analyzed the logs.
• Wrote stored procedures, Triggers, Cursors to implement business logic.
• Implemented and documented proactive monitoring scripts for production databases.
• Provided support for ETL developers in loading of client’s data into SQL Server using ETL tool.
• 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.
• Fine tuning the Database Settings as well as the Server Settings.
• Configured Mail Profile for sending automatic mails to the respective people when a job is failed or succeed. Maintaining SQL Script for creation of Database Objects.
• Configured built in log shipping with SQL Server 2000.
• Importing and Exporting of the Database using DTS utility.
• Created and Scheduled DTS packages to transform data from Flat files and XML files etc.
• Creating, maintaining the users, roles and granting privileges.

Environment: SQL Server 2005/2000, T-SQL, Visual Studio 6.0, Windows 2000, NT 4.0, Erwin 3.5