SUMMARY

• 11 + years of IT experience as Agile Enterprise MSSQL DBA /Architect with and Development in various RDBMS systems (MSSQL 2000, 2005, 2008 and 2008 R2, 2012,2014, Oracle 9i, 10G, 11G, Golden Gate replication, ASM, RMAN, MySQL 4,5+ Innodb, MyISAM) in Production, Development and Test Environments.
• Took training for ITIL and PMP, for qualified leader ship qualities. With working knowledge of L2, L3, L4 SME for Microsoft stack.
• Strong DBA within all environments pre and postproduction support and maintenance activities.
• Good at system thinking where the moving parts of the system interact with the whole infrastructure, with a knowledge of various / domain business and lot of interpersonal and professional skills collaboration, facilitation and negotiation skills very good communication skills and written skills,
• Have extensive experience in Various types of Data Modeling, Relational Data Base Architecture and Implementation, Systems Architecture and Development, Database Administration and implementation of Administration Standards & Practice using Sybase/MS SQL Server/Oracle/MySQL.
• I have been involved in large number of project development, managed large number of Projects & been a DBA with large number of Data Servers.
• Had VB.net development experience as a developer for developing crystal reports and developing backend compatible interface with SQL Server as DB layer.
• Managed and coordinated several software releases from development to QA and then to UAT and Production. Developed various feature enhancements ASP.NET web application. Created dozens of custom reports and queries used for state submittal packages and internal data analysis. Tools utilized - C#, ASP.NET, ADO, SQL Server 2008, IIS, CSS.
• Associated with financial services industry (Banking, Investment Banking, Hedge Funds and some Insurance) and as well as Health and Insurance industry, Pharmaceutical domain.
• I have a lot of liaison experience between technology, marketing, operations and management. Very well versed in translating Business requirements to Technology development/administration/maintenance.
• Well experienced in setting goals and priorities for technology to reflect business needs and rules. I have been involved all facets of Technology management and Business Liaison.
• Highly skilled in handling the enterprise level databases with multiple terabytes of sizes, and mission critical DB’s with proper implementation of HA and DR.
• Expertise in Database Design, Administration, Implementation and Application Development.
• Strong experience in designing implementing and supporting VLS data warehouse DB’s.
• Experienced in new OLAP database cache database.
• Database Evangelist for SQL/BI technology.
• Working closely with business and performing job duties and responsibilities according to the organization’s business systems development methodology also its Systems Development Life Cycle (SDLC) methodology.
• Experience in SQL Server 2005/2008 Installation, Configuration of Stand-alone with multiple instance in Clustered and Non-Clustered environments.
• Migration/upgrading of SQL Server and applying Service Packs.
• Migrating and new installations of SQL Server on Hyper-V & VMWARE environments.
• Extensive experience in high availability SQL Server Solutions that includes Mirroring and Clustering.
• Experience in creating Log Shipping and Replication (snapshot, transactional (P2P) and merge) for various customers.
• Strong T-SQL and PL/SQL coding skills.
• Supporting the SQL Server instances, which are lying on the Windows Hyper-V servers.
• Experience in evaluation of database performance, tuning, backup, and restoring and disaster recovery of databases and enhancing the Performance by table partitioning.
• Extensive experience in controlling the user privileges, roles, monitoring the security and Audit issues.
• Worked with MySQL Environments for couple of clients with their requirement for administration installation and configuration.
• Installed and configured the IIS webserver along with system requirement gathering and suggesting without compromising the performance of the in-house SharePoint servers and web based application servers.
• Expertise in using various SQL Server Tools like Enterprise Manager, Management Studio, Query Analyzer, Profiler, SQL Server Agent, DTS, SSRS, SSAS and SSIS.
• Provided 24/7 support in monitoring, troubleshooting, optimization and tuning of SQL Server environments and Good hands on performance and tuning issues and developing and implementing emergency fixes, resolving database problems.
• Monitored and tuned SQL Server performance using System Monitor, SQL Profiler, Query Execution Plans and checking the consistency of database using DBCC Utilities.
• Reviewed and optimized queries using index Tuning wizard, Database Tuning Advisor to help dev. teams to achieve better performance. Documented solutions to database issues.
• Created maintenance plans to perform index de-fragmentation, re-indexing and updating the index statistics. Expertise with Table Design, Index Design and Performance Tuning, Table Partitioning.
• Had basic understanding of JDBC coding required for proper configuration and accessing the data from SQLDB.
• Proper understanding and handling of error messages from Java based applications and escalating to the application team about the errors.
• Involved in setting up SQL Jobs, Alerts, Database Mail and MOM.
• Had Good Experience in Configuration and Alert Monitoring and Maintenance of SCCM Versions.
• Good experience in SQL Server Programming, Integration Services and Reporting Services.
• Migrating packages from SQL server 2005 to SQL Server 2008.
• Load data into ETL through different data sources like oracle, Teradata, SAP.
• Experience in working with production and 24 x 7 on call environments.
• Strong mentor for serious workaholic.
• Creator and Owner of Social Group/Page in Facebook “SQL Server Labs”, this is just sharing my experience by trying to help community of MSSQL, Oracle, MySQL DBA’s. and blog under construction.
• Member of SQL PASS community and proud blogger.

TECHNICAL SKILLS

Database Versions: Microsoft SQL Server, 2000, 2008 and 2008 R2, 2012,Oracle 9i,10g,11i, Cache, Golden Gate, MySQL Server 4, 4.5, 5+ Enterprise ( Innodb)

Database Tools: SQL Server Management Studio, Enterprise Manager, SQL Profiler, Query Analyzer, DTA, SSIS, SSAS, SSRS, Toad for SQL Server, RED Gate Tool Belt.

Web Tools: MS-Front Page, Visual Studio 2008/2005, XML, CSS, HTML, and IIS

O/S: Unix (Sun Solaris, IBM AIX, HP/UX), Linux (RHEL 4&5), OS/MVS, VM/CMS, Windows XP, Windows 7, Server / 2003/2008/ 2008 R2, VMware (VMware Servers, Work Stations), Microsoft Hyper-V Servers

Hardware: Sun Servers, HP Servers, Wintel Workstations & Servers, IBM Mainframe

Languages: Java, C#, C++, PL SQL, Shell Scripting, Perl, ASP.NET, ADO, IIS, CSS

Tools: OLTP, OLAP, SQL Server Management Studio, DB Artisan, PowerBuilder, Power Designer, Rapid Sql, Erwin Data Modeler, Oracle Sql Developer, Toad for SQL Server, Toad for SQL Server, Spotlight Enterprise, Fog Light Enterprise for SQL Server, NetVault LiteSpeed, Oracle Sql Loader, NETIQ Plate Spin, Logic Monitor, SAN Monitor

PROFESSIONAL EXPERIENCE

Confidential, Fort Worth, TX

Consultant & DBA MSSQL / Architect

Responsibilities:

• Working with BNSF is totally a new experience cause of the domain experience I am learning and my skill set from technical and functional side, as a consultant is the major turnarounds,
• Working here with SQL Server, Oracle and DB2 as the mid-tier technologies. Along with DBaaS oriented based service, this is a purely a client based environment build up on AT&T and Soft layer Cloud systems, Where AT&T supports all types of applications other than IBM software, and Soft layer hold only build up for IBM based OS and applications,
• The environment requires very dynamic and fast decision maker with good experience in solution and designing background with Enterprise level systems.
• Roles and Responsibilities are working with the team as an Sr. DBA for on call rotation and with my skill set and with my past experience helping team and organization grow by giving them technical support in architecture and designing the DB and all related technologies.
• 24 X 7 Oncall L3& L4 support for Critical databases.
• Well versed what would be escalation engineer and SME as single point of contact for escalation.
• As a Solutions specialist and Modeler Architect by designing the best solution for existing and new DB’s for supporting the projects in pipeline and in implementation phase.
• At BNSF on a day to day activities working with Production issues, Work orders, incidents and change requests.
• Did migrations from 2008 R2 to 2012 and 2014, and new installations of SQL Server 2012 and 2014 along configuring HA DR using cluster and Always ON with AG groups.
• Applied SP1 and SP2 on 2012 along with CU’s for fixing the online rebuild index problem in 2012. Applied hotfixes CU’s for 2014 to fix the HA AG user group complaining about the joining the group while changing the primary and secondary and readable mode.
• Trouble shooting performance issues heavy tuning for SQL in SAP enterprise with terabytes of data on VM machines.
• Setting up mirroring and Log shipping for reporting and DR purposes as requested by vendors.
• Setting up SSIS packages and migrating from lower environments to latest editions of SQL and trouble shooting issues with the packages and containers with migration issues.
• Working with BI stack includes SSRS, crystal reports. troubleshooting performance issues and creating SSRS reports and moving them between environments.
• Documenting the procedures and stream lining the processes with more robust jobs in place.
• When ever-required taking initiative for new projects role outs with suggesting optimal storage requirements along with resources and server requirement.
• Optimizing VM I/O Performance is the number one concern for running SQL Server on a VM. The bottleneck of most database servers is I/O and not processing power. This is especially true for SQL Server running on a VM.
• Good Knowledge on working with SSIS and SSRS. Helped dev team in developing and deploying SSIS and SSRS Packages.
• Environment: SQL Server 2005 and 2008,2012 SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS) and Windows /2003/2008,/2012 R2 Tivoli.
• Scheduling backups using scheduled jobs and TSM and CommVault tools.

Confidential, Plano TX

Sr. Database Administrator

Responsibilities:

• Optimization of information management approaches through an understanding of evolving business needs and technology capabilities.
• Work with solutions architect(s) to provide a consensus based enterprise solution that is scalable, adaptable and in synchronization with ever changing business needs along with the root cause analysis and providing the permanent or standard solution and preventive measure.
• Management of the risks associated with information and IT assets through appropriate standards and security policies.
• Direct or indirect involvement in the development of policies, standards and guidelines that direct the selection, development, implementation and use of Information Technology within the enterprise.
• Primary responsibility as a Database Analyst Developer would be planning designing and managing and requirement gathering, analyzing the existing database systems and criticality.
• Work closely with development team to design and implement SQL Server databases and integrations for business applications using the inbuilt and Enterprise License software’s.
• Planning the migration using various technologies like Plate Spin, Replication, and Log Shipping & Mirroring depending on the criticality of the application and database with minimum or no downtime.
• Designing and tuning the existing and new daily and scheduled enterprise level reports using SSRS 2008 & 2012 versions, not only limited but using SSIS integrating and developing and implementing & developing the new IS jobs for data processing and clean sizing.
• Designing and documenting the LLD’s and HLD’s and POC’s where ever required for smooth transition.
• Team coordination and resource onboarding as per requirement.
• Working closely with Client and business team to explain the migration process and getting the feedback with the filling the bridge between the Management and client.
• Preparing POC for the migration plan proposed.
• Setup Golden Gate replication in Lower environments and ASM configuration for 11g.
• Setup RMAN Backup’s and maintaining the company standards.
• The above listed roles and responsibilities are not limited above as defined, work and responsibilities keep changing depending up on work and assignment.

Confidential, Fort Worth TX

SQL Server Database Administrator III / L3 support

Responsibilities:

• Installed, configured, administered and secured SQL Server 2012/2008/2005/ on Server and Clients.
• Gathering and Suggesting of Storage (SAN) with future analysis for top notch performance and redundant.
• Managed Logins, Users, Roles and User permissions, and conducted backup and recovery
• Involved in creating Schemas, Logins, Tables, Clustered and Non-Clustered Indexes, Views, Functions and Stored Procedures.
• Installing TDP and Control-M agents for SQL Backup according to the norms.
• Installed and configured cache database for vaccines and drugs administration platform for unique requirement.
• Supporting on call rotation on weekly and monthly basis. For supporting applications with multiple flavors of DB’s as back end some of them are Oracle, MSSQL, Sybase, Teradata.
• Involved in General Database Administration, Query Performance tuning, and validated some of the existing schema.
• New SQL Server 2008 R2 installations on VMware host servers and Hypervisor environments.
• Developed administrative tasks of SQL Server of performing daily Backups and recovery procedure.
• Implemented high availability techniques mainly Replication, Log shipping and involved in planning and monitoring Log Shipping.
• Optimizing VM I/O Performance is the number one concern for running SQL Server on a VM. The bottleneck of most database servers is I/O and not processing power. This is especially true for SQL Server running on a VM.
• Created SAN storage replication with asynchronous type of replication for one of the mission critical Pharmaceutical database, which is of 1.8 TB size data.
• Enhanced Performance of Database by implementing table partition on multiple tables with hundreds of GB sizes, tuning by creating table partition by date range, and also by creating multiple data file groups for max utilization of I/O’s.
• Performance monitoring and taking steps to improve the I/O throughput is one of the most important factors when setting up SQL Server VMs.
• Suggesting the rite hardware for hosting SQL Server on Hyper-V like suggesting the different types of VHD’s supporting Dynamic, Virtual, and Pass through.
• Installed and Configured Transactional and Snapshot Replication for production servers to other production servers available in remote location and also to Reporting server.
• Successfully implemented Database Mirroring with High Availability Mode in SQL 2005 and installed SQL Server in a cluster Environment.
• Created alerts and notifications for system errors, insufficient resources, and fatal database errors.
• Migrated from SQL Server 2005 to SQL Server 2008. And migration of ETS packages to SQL Server 2008.
• Migrated SSRS Reporting Server from 2008 R2 to 2012 SQL Server.
• Migrated SQL 32 bit version to 64-bit version on 2005 SQL Version.
• Running DBCC Consistency Checks and fixing Data Corruption in user databases.
• Helped developers team in developing and deploying SSRS packages.
• Scheduled and monitored all maintenance activities including database consistency check, index defragmentation.
• Heavily used Transactional Replication, Configured between Primary Server and three Read - Only servers and experience in troubleshooting replication problems.

Environment: SQL Server 2000, 2005 and 2008, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS) and Windows 2000/2003/2008 , and Toad Analyzer, Red Gate Tool Belt.

Confidential, Irving TX

SQL Server Database Administrator /MySQL Server DB & VB.net developer

Responsibilities:

• Installed, configured, administered and secured SQL Server 2012/2008/2005/ on Server and Clients.
• VB.net application development and performance enhancement by fixing bugs in reports.
• Topnotch cutting edge performance and design recommendations using .net for faster and reliable web application used to take orders and process the order history.
• Gathering and Suggesting of Storage (SAN) with future analysis for top notch performance and redundant for .NET and Java based applications.
• Implementation of Merge Replication between Server and Client SQL nodes.
• Installed MySQL 5 Community version and Configured and managed the 300 Gb database.
• Managed Logins, Users, Roles and User permissions, and conducted backup and recovery.
• Worked with Netezza DB extracting and transforming data.
• Involved in creating Schemas, Logins, Tables, Clustered and Non-Clustered Indexes, Views, Functions and Stored Procedures.
• Involved in General Database Administration, Query Performance tuning, and validated some of the existing schema.
• New SQL Server 2008 R2 installations on VMware host servers and Hypervisor environments.
• Developed administrative tasks of SQL Server of performing daily Backups and recovery procedures
• Implemented high availability techniques mainly Replication, Log shipping and involved in planning and monitoring Log Shipping.
• Implemented table partitioning depending on range.
• Optimizing VM I/O Performance is the number one concern for running SQL Server on a VM. The bottleneck of most database servers is I/O and not processing power. This is especially true for SQL Server running on a VM.
• Performance monitoring and taking steps to improve the I/O throughput is one of the most important factors when setting up SQL Server VMs.
• Suggesting the rite hardware for hosting SQL Server on Hyper-V like suggesting the different types of VHD’s supporting Dynamic, Virtual, and Pass through.
• Installed and Configured Transactional and Snapshot Replication for production servers to other production servers available in remote location and also to Reporting server.
• Successfully implemented Database Mirroring with High Availability Mode in SQL 2005 and installed SQL Server in a cluster Environment.
• Created alerts and notifications for system errors, insufficient resources, and fatal database errors.
• Migrated from SQL Server 2005 to SQL Server 2008. And migration of ETS packages to SQL Server 2008.
• Migrated SSRS Reporting Server from 2008 R2 to 2012 SQL Server.
• Migrated SQL 32 bit version to 64-bit version on 2005 SQL Version.
• Running DBCC Consistency Checks and fixing Data Corruption in user databases.
• Helped developers team in developing and deploying SSRS packages.
• Scheduled and monitored all maintenance activities including database consistency check, index defragmentation.
• Heavily used Transactional Replication, Configured between Primary Server and three Read - Only servers and experience in troubleshooting replication problems.
• Fine-tuning the Java based applications, which are accessing the SQL DB through JDBC by having up to date JDBC drivers required and proper binaries installed.
• Support in-house maintained SharePoint servers by installing and configuring the IIS services along windows AD.

Environment: SQL Server, 2005 and 2008, 2008 R2 SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS) and Windows /2003/2008, and Toad Analyzer, Red Gate Tool Belt.

Confidential, Morrisville, NC

SQL Server Database Administrator

Responsibilities:

• Installed and configured SQL Server in Production and Development environments.
• Involved in upgrading MS SQL Server on development and test environments.
• Worked as an outsourced consultant solely responsible for designing, developing and maintaining SQL Server databases containing customer information.
• Design and implementation of database Logical and Physical Schemas.
• Created Replication and Log Shipping for different customers.
• Implemented Log Shipping in SQL Server 2005 from Primary Server to Standby Server.
• Responsible for creating, maintaining and monitoring mirrored servers.
• Worked in failover cluster environment Active/Active and Active/Passive nodes
• Applied patches to SQL Servers in Cluster environment.
• Assist in developing Normalization.
• Estimation of Table sizes and Record sizes.
• Responsible for database tuning using normalization and application tuning.
• Extensively involve in replication and implementation of Snapshot, Transactional Replications.
• Successfully implemented Transactional replication, Clustering and mirroring.
• Check Performance Tuning, Indexing, Query Optimization, Integration of Third Party Databases.
• Used Performance Monitor/Profiler to solve Dead Locks/Long running queries.
• Creation and maintenance of databases and objects like Tables, Views, Indexes, Stored-Procedures, Triggers and Cursors, Users and User Group creation and maintenance.
• Document disaster recovery plans and participate in disaster recovery.
• Take different types of backup including transaction log, Perform database consistency checks.
• Perform data migration between different environments and third party databases.
• Interact with the users and troubleshoot the problems involved with development.
• Schedule DBCC consistency checks.
• Good Knowledge on working with SSIS and SSRS. Helped dev team in developing and deploying SSIS and SSRS Packages.

Environment: SQL Server 2005 and 2008, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS) and Windows /2003/2008, Tivoli.

Confidential, Nashville, TN

SQL Server Database Administrator

Responsibilities:

• Installed, configured, administered and secured SQL Server 2005 on Server and Clients tools. Maintained over 40+ SQL Servers in Production, QA, Test and Development Environment.
• Designed, implemented, and administrated databases in SQL Server 2005, 2008.
• Managed Logins, Users, Roles and User permissions, and conducted regular backup and recovery.
• Involved in creating Schemas, Logins, Tables, Clustered and Non-Clustered Indexes, Views, Functions and Stored Procedures.
• Worked in failover Cluster environment Active\Active and Active\Passive nodes.
• Applied patches to SQL servers in cluster environment.
• Implemented High availability techniques Mainly Replication, Log shipping, Mirroring.
• Migrated SQL 32 bit version to 64-bit version on 2005 SQL Version.
• Involved in General Database Administration, Query Performance tuning, and validated some of the existing schema.
• Installed, configured and maintained Reporting services boxes.
• Involved in supporting application team in production releases for replication change and schema changes.
• Used SCOM and SQL Sentry to create alerts and notifications for system errors, insufficient resources, and fatal database errors.
• Created SSIS Packages to migrate slowly changing dimensions
• Migrated packages from SQL Server 2000 to SQL Server 2005.
• Deployed SQL SERVER INTEGRATION SERVICES (SSIS) packages, Configured Log shipping.
• Captured and analyzed the long running stored procedures using SQL Server Profiler and tuned the same to optimize application and system performance.
• Scheduled and monitored all maintenance activities including database consistency check, and index defragmentation by DBDEFRAG and DBREINDEX and statistics update.
• Helped application teams in query analyzing and its optimization. Coordinating with users for downtime.
• Provided 24/7 in SQL production support.

Environment: SQL Server /2000, Windows 2K/2003, SQL Profiler, Migration, ETL, DTS, T-SQL, Lite speed, SCOM, SQL Sentry

Confidential

SQL Server DBA

Responsibilities:

• Up-gradation of SQL databases from SQL Server 2000 to SQL Server 2005.
• Monitored and tuned databases to meet the performance and availability requirements of on-line systems and multiple applications.
• Implementing Automated Backup and Database Maintenance / Cleanup jobs and high availability techniques.
• Managing the Clustering environment.
• Scheduled and monitored all maintenance activities of SQL Server 2005 including database consistency check, and index defragmentation by DBDEFRAG and DBREINDEX.
• Monitored database status including CPU, memory, I/O, space, and dead lock using SQL Server Utilities
• Modified DTS to SSIS packages to accomplish critical business logic.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Configured Server for sending automatic mails to the respective people when a SSIS process failure or success.
• Develop Data Warehouse ETL process using SSIS (Integration Service)
• Data migration (import & export - BCP) from Text to SQL Server.
• Regularly monitored the system for bottlenecks (CPU, RAM, Disk IO and Networking).
• Used Erwin to reverse engineer the existing database design in MS SQL Server 7.0
• Created Jobs to Automate & Scheduled many tasks.
• Created multiple data file groups
• Used SQL Profiler for troubleshooting, monitoring, optimization of SQL Server and non-production database code as well as T-SQL code from developers.
• Worked on all phases of database management with application development team and other vendors to maintain maximum availability.
• Had good experience in 24/7 in SQL production support.

Environment: SQL Server, Windows /NT, Excel, Access, SQL Profiler, SSIS, Enterprise Manager, ETL, DTS, T-SQL, BCP.

Confidential

SQL Server DBA/Developer

Responsibilities:

• Created DTS packages for the loading the data.
• Used the reporting services to create, schedule and publish the reports required.
• Implemented and maintained database security. Administrator tasks like managing users, roles, and profiles.
• Performed Database backups (operating system, flat file backups & export/import).
• Used Snapshot replication for creating multiple instances of a database for distributing the workload.
• Configured Snapshot Replication (Creating Distribution Databases, updating Publishers, creating & managing Publications, managing Replication monitors).
• Tuned SQL statements and SQL Procedures.
• Combined a few simple, unrelated Database Accesses to improve performance.
• Used Query Analyzer to optimize SQL Queries.
• Maintained the physical Databases by monitoring Performance, Space utilization and Physical integrity.
• Coded Procedures & User defined Functions in TSQL.
• Established and documented a complete Disaster Recovery Plan for the Database servers.
• Rebuilding indexes on various tables.

Environment: Microsoft SQL Server, Windows /XP, Microsoft SQL Server Enterprise Manager, Crystal Enterprise, DTS, SQL Profiler.