SUMMARY:

• A talented IT professional with over 10 years of experience in Design, Development and Support of IT, focusing SQL Serer 2008/2005/2000/7.0 in Production, QA, Development environments. Possesses strong analytical, leadership, project management and communication skills.
• 9+ years of strong professional experience in database server administration, Development, Support.
• SQL Server 2000 - 9+Yrs, SQL 2005 - 5+Yrs, SQL 2008 - 3+Yrs, SQL 2012 - 3+Yrs, SSRS - 5+ Yrs, SSIS - 5+ Yrs, SSAS- 1+ years, Microsoft DTS - 9 years.
• Possess 3+ Yrs in Healthcare, 6+ Yrs in Financial Sector, 2+ Yrs Telecommunications, 1+ Yr in Retail industry and 1+ Yr in DotCom/e-Commerce experience.
• Experience in supporting transactional replication environments.
• Responsible for backing up and restoring SQL 2000, 2005, and 2008 databases.
• Working with outside auditors to keep the databases PCI, HIPAA and/or SOX compliant.
• Quick learner, with an ability to rapidly achieve organizational integration, assimilates job requirements and employs new ideas, concepts, methods and technologies. Energetic and self-motivated team player.
• Participated in the on-call rotation for SQL Server
• Excellent communication, interpersonal, intuitive, technical, analysis and leadership skills. Thrive in both independent and collaborative work environments.
• Responsible for maintaining, updating, and using full, differential and transaction log back ups for multiple SQL Server databases
• Providing consultation on SQL Server to our development teams.
• Create custom-tailored backup/restore and disaster recovery plans for production servers.
• Troubleshooting performance issues and fine-tuning queries and stored procedures.
• Defined and implemented Change Management policies and procedures.
• Participated in Change control board meetings, and provided various impact analysis as and when necessary.
• Reviewed and optimized SQL queries, stored procedures, views and triggers from other developers to achieve maximum efficiency and scalability.
• Worked in installation of SQL Server Clustering 2005/2008 in Active-Active and Active-Passive configurations.
• Experience working with large OLTP databases of more than 1.4 TB in size
• Implementing and administering database replication between SQL Server databases
• Experience defining ETL and system integration architectures combining data from disparate source systems and disparate data formats. Defined and implemented Change Management policies and procedures.
• Experience in upgrading database from SQL Server 7.0 to SQL Server 2000, SQL Server 2000 to SQL Server 2005/SQL Server 2008, and SQL Server 2000 to SQL Server 2008.
• Debugging deadlocks and other database inefficiencies using SQL Profiler.
• Experience working with both Production (7 x 24) and Development environment.
• Extensive background in the full software development life cycle (SDLC) from initial concept through final delivery and ongoing support.
• Creating application Schema (Database, Tables, Views and Indexes) and implemented various SQL, Transact-SQL statements, stored procedures and triggers according to the requirements of the project.
• Experience in using DTS/SSIS for the extraction, loading and manipulation of data from different systems including legacy mainframe systems.
• Experience in developing in both Agile and Waterfall development methodologies.
• Worked with Development Managers to effectively manage code base and ensure that application and database code versions are linked in source control.

TECHNICAL SKILLS:

Operating Systems: Microsoft Windows NT4.0 Server, MS Windows 2000/2003 Server, MS Windows 2008/R2 64-bit Server

Software Packages: MS Project, Outlook 98/2000, Quick Books Pro 2003 MS Virtual PC 2004, MS Visual Studio 6.0/2008

Hardware: Compaq, Dell PowerEdge Servers, Unisys servers, IBM Servers, Macintosh Desktops, Cisco Routers, Hubs, Switches.

RDBMS: Oracle 8i/9i/10g, MS SQL Server 2000/2005/2008 /2012 MS Access 2000/20058, MySQL

Database: SQL, PL/SQL, T-SQL (DDL, DCL, DML), MSDE 1.0, DTS, SSIS, SSRS, Confio Ignite, Idera DM, DigiOpsEnterprise Management Confidential XI, Crystal Reports 8.0/9.0/XI

Languages: Visual Basic 6.0, VB/ Active X Scripts

Version Control Tools: Visual Source Safe 6.0, Team Foundation Server - TFS

CASE Tools: Developer 2000, Visible Analyst, Visio 2000/2003

PROFESSIONAL EXPERIENCE:

Sr. Database Engineer

Confidential, Dallas, TX

Responsibilities:

• Worked in Biller solutions division of Confidential as Application Support Engineer.
• Identify problems with the application/code and provide immediate “stop the bleeding” fixes and work with Developers to create long term solutions
• Provide code review for new SQL development and suggest improvements
• Work extensively with Problem Management, Incident Management, Change Request modules of Remedy Service Management System
• Developed new solutions for biller account imports, reconciliation and reporting
• Monitor SQL Servers and identify bottlenecks and provide immediate relief
• Work with developers to identify bugs/issues with the code, .Net, VB6, Java etc
• Troubleshoot and modify existing DTS/SSIS packages for better error handling/reporting
• Create Recurring Client Import solutions on very large databases using SSIS packages.
• Worked on performance tuning objects to work with tables with over a billion rows.
• Assisted in development of security features for PCI compliance.
• Performed code review for new database objects and provided guidance to developers in Confidential Global Services, Pune, India

Technical: SQL Server 2000/2005/2008 /2012 , RedGate,, Visual Studio 2008/2010, Quest Spotlight, SSIS/SSRS, PowerGrep, Pragmatic BI Express, Remedy Incident/Change Management System,ServiceNow

Sr. Database Engineer

Confidential, Dallas, TX

Responsibilities:

• Worked in Database Development team (PeopleMedia division) to support multiple databases on multiple servers, serving over 30 dating sites, with thousands of concurrent users.
• Modified existing stored procedures and added new stored procedures, synonyms etc to add new features to websites using SQL Server 2008R2
• Worked with web developers (Cold Fusion and/or .Net).
• Worked in fast paced environment with bi-weekly and 3-week releases
• Extensively used TFS for code modification/checking etc.

Technical: SQL Server 2008 R2 64-bit, Visual Studio 2010, Team Foundation Server 2010, SQL Runner, DBHelper

SQL Server DBA/Developer

Confidential, Carrolton, TX

Responsibilities:

• Worked in Agile environment with daily scrum meets and bi-weekly sprints
• Created/modified SSIS packages to meet business requirements with custom scripting and error handling.
• Configured SSRS and created new reports as required by business.
• Managed 24X7 mixed environment of SQL Server 2000/2005/2008 with 10 total instances on 7 physical and 2 virtual servers.
• Supported databases and performed maintenance for Microsoft Dynamics NAV Business Management Software.
• Installed and configured SQL 2008 Enterprise Edition R2 on Windows 2008 Server R2
• Used RedGate backup to backup all enterprise databases
• New application development using TSQL stored procedures, SSIS.

Technical: SQL Server 2008 R2 64-bit, RedGate, SSIS, SSRS, Visual Studio 2008/2010, Team Foundation Server 2010

SQL Server DBA/Developer

Confidential, Irving, TX

Responsibilities:

• Performance tuned stored procedure using industry best practices related to table joins, temp tables, sort orders, cursors, error logging, indexes, correlated sub-queries, etc.
• Performance tuned DTS packages and underlying tables used in existing ETL processes
• Migrated databases from SQL 2000 to SQL 2008 using side-by-side method.
• Converted existing DTS packages into new SSIS packages as part of migration
• Worked with different teams and converted all scheduled PERL scripts into SSIS packages with scheduled SQL jobs
• Created SSIS Packages for data extraction from Flat Files, Excel Files and other RDBMS i.e. DB2, Oracle
• Designed, developed and implemented ETL process for data loading from multiple platforms and formats using SSIS packages.
• Created new and modified existing reports using freeware Jasper Reports tool.
• Worked with PERL/DELPHI/AWK scripts to convert the code into SQL and utilize stored procedures, SSIS packages and Jobs to replace Windows scheduled PERL scripts.

Technical: SQL Server 2000/2008, Windows XP Professional, Virtual Server, SSIS, DTS, PERL Scripts, Red Gate, Windows scheduler, Lotus Notes, Remedy, MS Visual Studio 2008, Jasper Reports (iReport 3.0)

SQL Server DBA

Confidential, North Richland Hills, TX

Responsibilities:

• Managed 24X7 mixed environment of SQL Server 2000/2005/2008 with 109 total instances on 72 physical and 13 virtual servers.
• Helped architect the upgrade and consolidation of the SQL Server 2000 environment to SQL Server 2005/2008.
• Centralized management and monitoring of the database environment using SSIS, SQLCMD, stored procedures, and SSRS.
• Leveraged Profiler, Confio Ignite, and Idera Diagnostic Manager in continuous performance tuning activities.
• Created and deployed SSIS packages and stored procedures that gathered data for centralized monitoring of the SQL environment. Leveraged SSRS to report on the data.
• Coded stored procedures and DTS packages for a number of development projects. Routinely tuned procedures for development projects.
• Responsible for deploying database objects into Unit, QA, and Production environments. Key participant in creating the development standards documentation.
• Standardized server and database configurations, alerting, jobs, and all facets of the environment. Wrote stored procedures and leveraged SQLCMD and Idera Multiquery to centrally manage these changes.
• Developed plan and prepared documents for use in Disaster Recovery.

Technical: MS Windows 2000/2003 Advanced Servers. Windows 2008 64bit R2, SQL Server 2000/2005/2008 , SSIS, SSRS, DTS, Red Gate, Confio Ignite, Idera Diagnostic Manager, Active-Passive Cluster, Active-Active Cluster, Subversion

SQL Production Support DBA

Confidential, Plano, TX

Responsibilities:

• Performed production support for the Data Warehouse jobs, on daily basis using Argent Job Scheduler (a third party tool)
• Responsible for monitoring the ODS, BEST and other jobs which load the DWH data, for smooth transferring of data from ODS servers to DWH servers.
• Responsible for Monitoring around 1500 ODS and DWH jobs, which starts loading the data from 00:30 AM till 2:00 PM on daily basis.
• Resolve issues with Job failures, long running jobs and late running jobs, responsible for delivering the data on time.

Confidential

Enterprise XI Administrator

Responsibilities:

• Managed Crystal Reports jobs servers and Mail servers.
• Responsible for monitoring all the Crystal servers services, troubleshooting the servers and start and stop the servers in case of failures.
• Scheduling of Crystal reports via Crystal Enterprise XI and InfoScheduler (a third party MS Excel based scheduling tool)
• Performed Promotion of New and Modified reports using Crystal Reports XI
• Decommissioning of Crystal reports as per Client Request.
• Managed objects and Crystal Events, stop, start and Pause the reports on request.

Technical: SQL Server 2000, Windows XP Professional, Argent Job Scheduler, Crystal Enterprise XI, InfoScheduler, MS Excel, MS Access 2000, MS Visio, Active X Scripts, REMEDY

SQL/DTS Developer/DBA

Confidential, Irving, TX

Responsibilities:

• Created DTS packages utilizing Active X and VB Scripts with file transfers and folder manipulations
• Managed the scheduling of the packages by creating jobs
• Created DTS packages to import data from other RDBMS i.e. Informix, Oracle, DB2
• Created stored procedure by implementing business logic for compensation
• Developed scripts with Transact-SQL (DDL, DCL, DML) for data loading.
• Automated the daily database feeds from the field offices through secure ftp servers.

Technical: MS Windows 2000/2003 Server, MS SQL Server 2000/2005 (YUKON), MS Windows XP/2000, MS Excel, MS Access 2000, MS Visio, ERWIN, MS Visual Studio 6.0, MS Visual Source Safe 6.0,MS XML 6.0,Crystal Reports 9.0, VB Scripts, Active X Scripts, MS Cluster Services

Development DBA

Confidential, Irving, TX

Responsibilities:

• Developed Application Programming Interface (API) for eSales Product Catalog.
• Designed tables and database schema
• Created functions as generic database layer for all the applications to use.
• Created stored procedures by employing complex business logic for getting the products for Pricing and Ordering applications
• Developed API layer by integrating with the Database interface (DBI)
• Worked with .Net Developers and helped in creating a BL (Business Layer).
• Created stored procedures by categorized data for loading products and pricing.
• Performance tuned the stored procedures to achieve minimal execution times.
• Create development kits and enhancement changes from Visual Source Safe and push them to Staging and Production environments
• Managed and QA the stored procedure in System Test, Staging and Production.
• Worked on automating the weekly data feeds from VPF ( Confidential Product Factory)

Technical: MS Windows 2000 Server, MS SQL Server 2000/2005 (YUKON), MS Windows XP/2000, MS Excel, MS Access 2000, MS Visio, ERWIN, MS Visual Studio 6.0, MS Visual Source Safe 6.0, ClearCase 2.0,MS XML 6.0,Crystal Reports 9.0

SQL DBA / Developer

Confidential, Irving, TX

Responsibilities:

• Create new stored procedures by implementing business logics
• Create new databases on Order Placement and Order Fulfillment Servers.
• Support and troubleshoot transactional replications between Order Placement servers and Order Fulfillment servers.
• Debug and modify existing stored procedures for query response optimization depending upon changed or new requirements.
• Create development kits and enhancement changes from Visual Source Safe and push them to Staging and Production environments
• Manage dataload for the Confidential product catalog to bring it from backend servers and load it onto SQL servers using the DTS packages.

Technical: MS Windows 2000 Server, MS SQL Server 2000, MS Windows XP/2000, MS Excel, MS Access 2000, MS Visio, MS Project, ERWIN, MS Visual Studio 6.0, MS XML 6.0