PROFESSIONAL SUMMARY:

• 12+ years of IT experience in Database Administration, Design Development and Support of MS SQL Server 2012/2008R2/2005/2000 in Production, Test, Development and Cluster Server Environments.
• Hands on experience in installing, configuring & provide day to day DBA support to MS SQL server 7 to 2012, DB2 8x,9x, Syabase15x, Oracle9,10g,11gx 12c, MySQL 5x, Postgres 8,9 production database servers. Leading a team of 10 DBAs
• Experience in RDBMS database design, performance tuning, optimization, backup and recovery in SQL Server 2000 and SQL Server 2005/2008/2012 .
• Experience in Disaster Recovery Planning, Execution and Testing at remote side.
• Experience in using SQL Server Tools like DTS, Import/Export Wizard, SQL Server Enterprise Manager, SQL Profiler and SQL Query Analyzer.
• Migration experience from MS SQL Server 2000 to MS SQL Server 2005/2008/2012 , MS SQL Server 2005 to MS SQL Server 2008, MS SQL Server 2008 to 2014
• Provided expertise in Data warehouse and Data Marts methodologies as well as extensive knowledge of OLTP/OLAP technologies
• Experience in Database administration activities for DB Security (creating logins, users, roles, and assigning permission to them)
• Master in performing administrative tasks: database files management, backup/restore, security management, Database Mirroring, data integration and synchronization.AWS Cloud
• Extensive use of DTS/SSIS in SQL Server, Performance Tuning & Index Tuning, Disaster Recovery Planning, Security Management, Managing server and clients.
• Experience in implementing high availability using Log shipping, and knowledge of DB mirroring in SQL Server 2005
• Extensive experience with IIS (Internet Information Services) 5.0/6.0.,Amazon Web Service
• Solid experience on high availability SQL Server solutions, including Replication Models, (Snapshot/Transactional) and SQL Server clustering (Active - Active, Active-Passive)
• Expert in using Bulk Copy Program (BCP), Data Transformation Services (DTS) packages and SSIS (integration services) with MS SQL Server 2000/2005
• Experience in creating SSIS packages, DTS Migration & Metadata Management: Migrating DTS Packages to SSIS, Package Migration Wizard, and Storage Management.
• Experience in using SSIS (SQL Server Integration Services) for data extraction, transformation and loading across different databases like Oracle, MS Access and flat files using tools like Import and Export Wizard, Package Installation and SSIS Package Designer.
• Experience in designing/generating/using/deploying Visual Studio 2005 Business Intelligence Reports, SQL Server 2005 Reporting Services (SSRS), Crystal Reports
• Extensive work experience on system analysis, design, development, testing and implementation of projects with full SDLC (Software Development Life Cycle).
• Specialized in all aspects of database design and programming with Sybase Adaptive Server Enterprise, Replication server and Sybase IQ Server and Oracle 
• Data modeling, Database design, Transact SQL programming and Open Client programming performance & tuning issues and troubleshooting and security administration Long-standing experience with Sybase Adaptive Server enterprise (ASE) covering versions 10.x 11.0, 11.5, 11.9, 12.0, 12.5 and 15.0, starting in 1995.

TECHNICAL SKILLS:

Operating Systems: Windows Server 2003, Windows 2000 Server/ Advanced Server, Windows 8/XP/Professional, UNIX, Sun Solaris

Database Tools: Profiler, DTS, Management Studio/Enterprise Manager, Query Analyzer, SSIS, 

Web Technologies: XML, HTML, VBScript, SOAP, Amazon Web Services, VMWare

GUI Tools: Visual Studio (VB), Visual Studio2005/2003

Languages: VB 6.0, VB.Net, T-SQL, 

.Net Technologies: VB .NET, ASP .NET C#

Web Server: Internet Information Server 

Databases: SQL Server 2012/2008R 2/2008/2005/2000 , MS Access, Oracle 9i.10g, 11g 12c, DB2 9.1 to 9.7, Sybase 15, Mysql

Version Tool: Visual Source Safe

Reporting Tools: Business Objects, Crystal Reports

OLAP Tools: SQL Server Reporting Server 2008/2005, SSIS (as ETL)

Third Party Tools: Lite speed, Erwin, DB Moto.

PROFESSIONAL EXPERIENCE:

Sr. SQL Server DBA/ Architect

Confidential, St Joseph Michigan

• Design, maintain and build conceptual, logical and physical database models. Database architecture and creation, optimization, deriving conversion and migration methods for existing data, and developing automated conversion and migration methods
• Responsible for the planning, installation, configuration, maintenance and production monitoring of database instances.
• Performed end-to-end architecture and implementation strategy for RAC, GRID with ASM, DG, data Replication, upgrade/migration, patching and transformation. Oracle middle tier fusion and web-logic configuration as well.
• Configured and standardized the database access and roles for compliance and regulations.
• Responsible for Architect the enterprise database road-map and achieving the shared vision of the technology leadership group and the organization goals.
• Addressing the technical aspects of database business needs by recommending off-the-shelf and/or custom, in-house solutions. Off-the-shelf solutions will be researched, reviewed, and tested to conform and integrate to the environment
• Migrating the database to AWS as per the company roadmap.
• Meet with business stakeholders and other technical team members to gather and analyze application requirements
• Provides mentoring and support to all database teams and developers.
• Enhance overall team accomplishments and competence by planning delivery of solutions; mentoring less-experienced team members in technical and procedural processes; developing and training teams on improved processes; developing and maintaining documentation standards and ensuring database teams and developers understand these standards and use them to document environments they are responsible for supporting.
• Tracks emerging technologies; evaluating their applicability to business goals and operational requirements
• Researches and understands new and emerging technologies and recommends and develops solutions in conjunction with other technical leaders.
• Design database solutions to satisfy application (business and technical) requirements
• Implement database solutions using available database development tools, AWS Cloud
• Provide written status reports to management regarding project status, task, and issues/risks
• Develops, implements and manages the employer’s enterprise database technology road-map
• High availability
• Disaster recovery
• Enterprise Community environments
• Research solutions
• Regulatory requirements
• Reviews and implements non-standard database solutions that will function with the standardized database technology environment. Leads &facilitates information gathering sessions to document business and functional objectives. Facilitates & participates in modeling and other data initiatives addressing both new and existing systems.
• Participates in the employer’s Project Management Office design and scoping engagements that include database technologies
• Provides mentoring and database technology leadership to all IT teams and customers
• Implements architecture using custom components and custom designs, prototyping, and data migration that is consistent with technical integrity and consistency.
• Monitored the complete environment for resource utilizations and to avoid any bottlenecks
• Creating and maintaining various databases on Production and development environments using SQL Server 201 2/2008/2005/2000 ., Oracle 10g,11g, DB2 9,10
• Created jobs to import/ export data obtained from various States to update the Confidential servers.
• Installed and configured SQL Server Reporting Services.
• Installed necessary Service Packs for SQL server 2005,2008, 2012, 2014,stand alone,vmware
• Involved in Database Backup and recovery
• Managed 100 + enterprise-level MSSQL Server 2000 to 2014, Oracle 11g/10g DB2 9x,10x, Sybase 15 database systems, achieving the goal of 99.99% availability at acceptable level of performance.
• Participated in vital planning for infrastructure setup of the MMIS which involved geographically dispersed sites across the nation
• Managed team of on-site DBAs and off-site DBAs across global locations. DBA categorized of Administration, Application, Production, Operation, Change Management, NOC, On-call support and Optimization.
• Defined Cost Saving Structured Shared-Service Model for the operational DBA team servicing multiple projects
• Defined Outsource model across continents for rapid DB service requests Upgraded legacy 2000 databases to SQL server 2005/2008, 2005 to 2012, 2008 to 2012, 2014
• Managed and administrated database and database applications 24x7 that include Oracle 10g /11g/9i Databases, Siebel and Cognos application databases, Micro focus Cobol, RAC (real application cluster) clustering server, OEM Grid, High Availability, Data Guard, Web service applications (WebSphere and WebLogic) and IBM Rational products. Implemented and tested the point in time recovery of the production databases.
• Participated in quarterly meetings with Senior Management to discuss technical infrastructure and market recommendations assisting in the formation of the technology roadmap
• Lead database compliance effort in accordance with 21 CFR 11 and participate with internal and external audits resulting in fulfillment of VDA requirements
• Managed change control meetings ensuring that changes to production environments are validated and thoroughly tested. This effort reduced the number of outages by over 25%.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes whenever necessary worked on .NET & C# for optimization of application.
• Loaded the data into another data sources (Oracle, SQL Server) using SSIS.
• Created various SSIS packages based upon the requirement.
• Created various reports using SSRS
• Created the logical and physical data modeling using Erwin tool
• Expanded Physical Data Model (PDM) for the OLTP application using ERwin
• Managed security on Production and Development environments
• Analyzing the Performance of a Cube by partitioning it and creating Perspective Cubes
• Scripting the Database Consistency Checks (DBCC), scheduling the scripts to run daily and weekly basis
• Responsible for fine tuning of the database, troubleshooting, user administration, memory management, and running DBCC (Rebuilding Indexes and fine tuning Stored Procedures).

Sr. SQL Server DBA/ Architect

Confidential, Dallas Texas

• Managed change control meetings ensuring that changes to production environments are validated and thoroughly tested. This effort reduced the number of outages by over 25%.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes whenever necessary.
• Loaded the data into another data sources (Oracle, SQL Server) using SSIS.
• Created various SSIS packages based upon the requirement.
• Created various reports using SSRS
• Created the logical and physical data modeling using Erwin tool
• Expanded Physical Data Model (PDM) for the OLTP application using ERwin
• Managed security on Production and Development environments
• Analyzing the Performance of a Cube by partitioning it and creating Perspective Cubes
• Scripting the Database Consistency Checks (DBCC), scheduling the scripts to run daily and weekly basis
• Responsible for fine tuning of the database, troubleshooting, user administration, memory management, and running DBCC (Rebuilding Indexes and fine tuning Stored Procedures).
• Installed, configured and implemented monitoring of oracle 11GR2 with ASM on AIX, Linux, UNIX and Windows environments.
• Installed and configured 2 Node RAC on AIX, LINUX and UNIX environments.
• Installed and configured oracle one node RAC for 11gR2 with ASM.
• Performed disk and disk group management in ASM while installing 11gR2 RAC
• Monitoring Health checks of OCR, VOTING DISKS and troubleshooting issues in RAC environment (11GR2)
• Ensured that oracle database systems operate securely and efficiently
• Managing databases from planning and testing stages through implementation and support
• Performed day to day activities like resolving Tickets for multiple environments, provided Development Support, coordination with development for Application Tuning.
• Worked extensively on monitoring grid control database, configuration of error notifications, installing listeners, and adding them to the grid control
• Performed conversion Non RAC single instance to Real Application Cluster (RAC) database instances
• Installation and configuration of GOLDEN GATE for replication on 11gR2
• Configured parameters for the Bi-directional replication
• Implemented Data Guard (Physical standby) on Oracle 10g and 11g with high availability and performance configurations and participated in Data Guard Fail over tests.
• Performing switchover of database form primary to standby and standby to primary
• Configured Active data guard and performed Troubleshooting data guard environment.
• Migrated data from old 10g environments to new 11gR2 environments using database cloning and DATAPUMP (EXPDP)
• Weekly refreshes of database and schemas using DATAPUMP (EXPDP).
• Taking logical backups using EXPDP
• Data Refresh in Test and Integration Databases using Transportable Table spaces.
• Involved in migration of 10g environments to 11g
• Monitoring and scheduling backups for a database using OEM 12c grid control.
• Applied both CPU and PSU patches as per requirements
• Applied grid infrastructure PSU including database PSU to upgrade grid and database home to latest version using OPatch utility.
• Upgraded oracle 10g to the latest oracle version 11gR2 using DBUA and by applying required patches

Lead Database Admin/ Project Manager,

Confidential

• Data migration using DTS services across different databases like Oracle, MS access & flat files.
• Contacted various users in gathering the requirements and documented the necessary changes.
• Analyzed various backup compression tools available and made the recommendations.
• Created necessary templates for various requirements gathering and documentation
• Lead a team of 10 DBA
• Develop documentation for all new and re-designed processes.
• Define the need for new or improved tools to support monitoring needs of servers & applications; develop, test and implement tools; advise others on duty operation team and TAM.

Environment: Windows 2000/2003, MS SQL Server 2000/ 2005/2008/2012 /2014, Oracle 10g/11g,12c, SSRS, DTS, SSIS, BCP SQL Server Profiler, VB.NET, T-SQL, Erwin 4.0, Erwin 3.5.2, DBMoto, Database engine tuning Advisor, IIS.

Sr. SQL Server DBA

Confidential 

Responsibilities:

• Interacted with various internal customers / project tem on day to day basis and analyzed their SQL server environments.
• Analyzed various SQL server environments and suggested best practices for better performance.
• Administered the space usage of the various databases for various applications
• Automated consistency check of the database (DBCC) for SQL Server.
• Analyzed the complete environment for resource utilizations and suggested upgrades to increase I/O and avoid bottlenecks.
• Installed and configured SQL Server Reporting Services.
• Suggested various architectures that can be implemented after upgrading from older versions of SQL server to SQL server 2005.
• Proposed various high availability options to maintain the high availability of SQL server on various environments
• Used DBCC commands to check physical and logical consistency of the databases and rebuild indexes.
• Created various automated processes to update the Reporting services databases on a regular basis.
• Suggested and implemented various SQL Server Reporting services environments.
• Upgraded SQL server 2000 boxes to SQL server 2005 and acted as the point of contact for all developers.
• Upgraded SQL server 2005 to SQL server 2008 on a Clustered environment
• Designed and developed data warehouse data stores, and analyzed business requirements, developed target-source data mappings and delivering ETL processes for end-user OLAP and reporting initiatives (Used report services as and OLAP client schedule reporting tool).
• Primarily responsible for developing database solutions that provide the business with the information needed to make daily operating and strategic decisions. Perform data modeling activities, application performance tuning and code reviews.
• Implemented various high availability options for SQL server 2005/2008 including replication.
• Tested point in time recovery of the production 2008 databases using the traditional backup/restore technique.
• Setup replication for high availability
• Make modifications/and add new MDX queries to cubes.
• Installed SQL server and implemented resource utilization on the server.
• Converted many DTS packages to SSIS packages during the up gradation of the servers
• Involved in performance tuning and query optimization.
• Fixed and rebuilt many SSIS packages during the migration.
• Analyzed many databases in various environments for performance issues
• Monitored network for bottlenecks
• Involved in tuning various reports generated using SSRS.
• Documented the various observations made and suggestions on various environments

Environment: Windows 2000/2003, MS SQL Server  2000/2005/2008 , SSRS, DTS, SSIS, SSAS, VB 6, Erwin, SQL Server Profiler, T-SQL, SQL Loader, Database engine tuning Advisor, BPA, Upgrade Advisor

SQL Server Developer DBA

Confidential

Responsibilities:

• Installation and configuration of SQL Server 2005,2000/7.0 on Window 2000/NT OS.
• Managing of database objects like Tables, views, stored procedures, indexes etc.
• Written complex stored procedures and functions according to business requirements.
• Implementing Backups and restoring when necessary.
• Used BCP utility to publish table output to text files
• Developed DTS Packages to transfer the data between SQL Server database and files
• Creation and management of Database maintenance plan for various database consistency checks.
• Developed original system for tracking database objects (tables, views, procedures, etc.) over multiple Sybase servers using Unix Shell Scripting.
• Creating monthly transaction report for all sections. Developing of Multi-Lingual Reports using Crystal Reports
• Designed and Implemented Reports using Business Objects Full Client
• Reports were developed using Crystal Reports utility, SAP Environment
• Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.
• Worked on monitoring and tuning of SQL scripts. Created upgrade scripts for production database and supported it.
• Managing of users including creation/alteration, grant of system/db roles and permission on various database objects
• Develop documentation that sufficiently describes technical deliverable as required for internal controls so that the maintenance responsibility can be passed on to production support team.

Environment: SQL Server7.0/ 2000, Enterprise Manager, Windows 2000, SQL Profiler, DTS, Crystal Reports, Business Objects, T -SQL, BCP

Database Administrator

Confidential

Responsibilities:

• Troubleshooting and resolving SQL alerts and SQL errors arriving into the ticketing system or queue running on 2005,2000/7.0 on Window 2000/NT OS.
• Performing SQL Installs, Upgrades and Server configurations as per the specification
• Performing SQL Security Hot fix installations and upgrades as application requirement & schedule.
• Setting up Database Backups, DBCC, or other job set-up/installations as per the requirement
• Setting up log shipping, replication
• Responding to effects on SQL/SQL Agent / Cluster Services of Service Account Password changes.
• Responding to urgent Performance Monitoring and Tuning questions from support analysts and escalating data from investigations to TAM for the application
• Overall Database Design, Development, Optimization and Maintenance in Development regions
• Security and Access to Database
• Develop documentation for new issues which have been resolved so others on the team can leverage this information.
• Implementation of ERP module
• Implements architecture using custom components and custom designs, prototyping, and data migration that is consistent with technical integrity and consistency.
• Migrate the data from legacy system to the Int E view ERP product