Summary

• Over 12 years of Information technology experience.
• Over 7+ years of experience in Database Development/Administration and System Administration.
• Experienced in MS SQL Server 2008 R2, 2005, 2000 and Oracle 10g/11g in Production, Testing, Development Environments.
• Extensive knowledge and experience in developing Stored Procedures, Views, Triggers, cursors and Complex Queries on ORACLE and SQL Server.
• Conducted Database Backup and Restore, Attach and Detach, Export/Import, Recovery and Disaster Recovery procedures.
• Involved exclusively in Disaster Recovery plans like Backup/Restore, Database Mirroring, Log Shipping
• Experience in Maintaining SQL Server Security, creation of logins and users, configuring permissions and assigning roles to users.
• Created and Maintained Alerts, Notifications, Jobs, Job Steps and Schedules for system errors, insufficient resources, fatal database errors, hardware errors, security.
• Experience in data migration from Access/Excel Sheets using import/export and BCP utilities.
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC Utilities.
• Extensively Monitored Performance with multiple tools like Performance Monitor, SQL Profiler, Event Viewer, Index Tuning Wizard, and Database Tuning Wizard to achieve better performance, Resolve Dead Locks/Long Running Queries, accessibility and efficiency.
• Experience in Troubleshooting all database related issues.
• In Depth knowledge in analyzing Query Plans, Extended Stored Procedures and improving efficiency by re-indexing, update statistics, Recompiling stored procedures, Troubleshooting Dead Locks and capture data using SQL Profiler, Performance Monitor and DBCC Commands.
• Worked closely with management, applications development Team, and users on database solutions to resolve business problems.
• Experience on working with production Servers and 24 x 7 On-Call environments.
• Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.
• Actively involved in setting up Active-Active/Active-Passive clustering in production and Testing Environments and also troubleshooting issues with the same. Applied Hotfixes and Service Packs in clustering environments.
• Conducted Database mirroring in High Performance and High Availability mode and troubleshooting issues with the same.
• Experience in performing backups and recovery using RMAN, Cold/Hot Backups, export and import using Data pump

Technical Skills

Databases : MS-SQL Server 2000/2005/2008 R2, Oracle 10g/11g.
Languages : Java, PL/SQL, T-SQL, VB Script, Java Script, HTML, XML
SQL Server Tools : Management Studio, Enterprise Manager, Index Tuning Wizard, Database Tuning Wizard, Profiler, Query Analyser, Export & Import, Precise i3 for SQL Server, TOAD for Oracle, Data Pump, RMAN.
Operating systems : Windows 2008\\2003
Software Packages : MS Office 97/2000/XP, 2003, 2007, MS Outlook 2003, 2007, Visio

Education:

Bachelor in Computer Science & Engineering

Certifications:

MCTS: SQL Server 2008, Implementation and Maintenance
SCWCD: Sun Certified Web Component Developer
SCJP: Sun Certified Java Programmer

Experience

Confidential, Columbia, SC 2011 Nov - Till

Date Database Administrator
The application maintains the database system of encrypted call details, billing, Inventory, HR, and Financial activities. This engagement involves understanding of the production environment at Sprit Communication, Performance Tuning on their existing database. This includes several system/Database Administration/Backup analysis and management on routine basis operational tasks.

Responsibilities:

• Installed SQL Server 2008r2 on Standalone and Clustered Environments.
• Upgraded /Migrated of SQL Server from version 2005 to 2008r2.
• Installed Microsoft Service Packs/Patches/Hot fixes.
• Configured and administered SQL Clusters (Active/Passive, Active/Active), Database Mirroring, Replication and Log shipping.
• Conducted Backup and Restore of Databases and Schedule Maintenance plans to perform regular Backups.
• Performed Attach/ Detach, BCP, Import & Exports and Copy Database Wizard.
• Created Tables, Stored Procedures, Views, Triggers, Cursors and Complex Queries on SQL Server 2005/2008.
• Query Optimization and Performance tuning for optimization like maintaining/creating indexes, Create/Update Statistics, Tuning SQL queries.
• Analyzed Performance using Performance monitor in order to identify the bottleneck such as CPU, memory, IO, paging and SQL Server and also bottleneck of SQL Server such as buffer cache hit, memory, transaction, procedure cache, paging etc.
• Troubleshooting Memory Errors/Query Processing and usage of Memory and resolving errors pertaining to insufficient Memory.
• Collected data using PSSDIAG, MPS Reports, Profiler to analyze and tune for better optimization.
• Troubleshooting and resolved Blocking, Deadlocks and Long Running Queries.
• Performed Data Transfer/Migration using Export/Import and Data Transformation Services (DTS) and SQL Server Integration Services (SSIS).
• Developed, deployed and monitored SSIS Packages including upgrade from DTS to SSIS.
• Created Reports using SSRS 2005/2008.
• Utilized DMV's, Data partitioning and Performance Dashboards reports with SQL Server2005.
• Configured Snapshot, Transactional and Merge Replication of SQL Server databases and Troubleshooted Replication Problems.
• Created and Managed SQL Server Logins and Users as per the requirement with specific roles and permissions on production servers.
• Created various Jobs, scheduled & ran jobs and troubleshooted the failed jobs.
• Provide 24X7 support for the Critical issues like Server Failures and Database inconsistencies like Database Log File full, Suspect, Offline, Missing log files etc.
• Created and maintain oracle 10g database.
• Conducted Backup and Restore of oracle database.
• Performed Oracle Databases refresh/cloning using Data Pump and cold clone.
• Upgraded oracle database from 10g to 11g.

Environment: Windows 2008/2003, MS SQL Server 2000/2005/2008, T-SQL, Visual Studio.Net 2003, LITESPEED, MS Access, DTS, BCP, SSIS, SSRS, SQL Profiler. Apex log, Apex SQL Diff, APEX SQL Data Diff, APEX SQL Audit, Oracle 10g, PL/SQL, SQL Loader, SQL Developer, TOAD

Confidential, Columbia SC Aug 2010 - Nov 2011
DBA

The project deployment of university wide student applicationsin SQL Server 2005 and 2008 related to the AR, financial aid, and payroll. Our support tasks involve basic of planning the environment before the deployment and to the managing and maintenanceinvolving troubleshooting application and server performance issues and optimizing the SQL Server Enterprise environments to provide the optimized performance and Managing and Coordinating various Database related maintenance activities and issues.

Responsibilities:

• Created and maintained various databases for Production, Development and Testing environments using SQL Server 2008r2, 2005.
• Actively involved in setting up Active-Active/Active-Passive clustering in production and Testing Environments and also troubleshooting issues with the same. Applied Hotfixes and Service Packs in clustering environments.
• Conducted Database mirroring in High Performance and High Availability mode and troubleshooting issues with witness servers.
• Involved in migration of SQL 2005 TO SQL 2008r2
• Performed daily backups and developed recovery procedures
• Migrated the data across different databases and different servers using SSIS, BCP and Import/export tools.
• Experienced in performance tuning using windows performance monitor and SQL profiler of SQL server. Used SQL Server error-logs and event viewer to troubleshoot issues.
• Implemented and configured database monitoring tools and focused on providing a high availability database.
• Configured and maintained Transactional and Snapshot replication
• Troubleshooted issues with log file full and database size increasing beyond threshold.
• Creation of new database, planning the location of data, index, and transaction log files on the disks
• Involved in Capacity Planning, data modeling and Logical/Physical database Design
• Involved in Change Control Management is the discipline of systematically identifying and controlling change requests to a project from both internal and external sources
• Provided support to the application developers on the application databases
• Handled the database components of application releases
• Handled 24/7 production issues
• Used i3 performance tool and Hydra software to monitor Databases and Servers.
• Performed Stress tests and monitored tests in regards to CPU, network bottlenecks and latencies, blocking and long running queries, page faults.
• Worked closely with application developers to help determine any issues with sql script, sql server performance, normalization, security and database/server connectivity and database schemas.
• Developed and deployed stored procedures, created triggers and audits.
• Developed Jobs for maintenance in terms of updating statistics, rebuilding indexes, scheduled full/diff/log backups, refreshing database environments periodically or on demand. Also set up notifications for failure of jobs etc.
• Actively participated in determining the database schema, database schema changes, implementation plan for database schema releases in coordination with developers and data modelers in adherence with Organization policies.
• Proactively monitored, determined and solved issues at sql/database/server levels.

Environment: Windows 2008/2003, MS-SQL Server 2008r2/2005, .NET Framework, Visual Studio, SSIS, SSRS, i3 performance tool, Argos, Oracle 10g, PL/SQL, T-SQL, SQL Loader

Confidential, Greenville, SC 2009 Feb -2010 July
SQL Server DBA
Confidential, is multinational company have developed smart, technology-enabled solutions to solve clients\' toughest challenges, demonstrating a commitment to excellence and a passion for exceeding expectations. This engagement involves database design, consultation of SQL servers, installing, maintaining and configuring client's production servers. Infor Global Solution maintains terabytes of information about their products and their customers. As part of SQL team my role was to provide database administration services for various core HR and financial applications.

Responsibilities:

• Involved in Administration, Database Design, Performance Analysis, and Production Support for Large (VLDB) and Complex Databases of more than 1 Terabytes.
• Installed, Configured and Maintained SQL Server 2008 in multiple database environments, namely development, QA and Staging. Applied Service Packs & assisted Infrastructure Engineering team to install and configure SQL Server 2008 in a Clustered (Failover) Environment.
• Provided Primary support DBA to various business critical SQL Server applications hosted over 300 servers (SQL 2008/2005).
• Upgraded to SQL Server 2008 and guiding the development and application team to fully utilize SQL Server 2008 enhancements.
• Created Merge Replication between different data centers. Resolved issues; designed and managed database security.
• Monitored Databases for Dead Lock, Capturing long running SQL queries, used HINTS for fine-tuning SQL statements that better result in efficient SQL statements processing.
• Used SQL Server Profiler to monitor the server by running traces on various events like User connections, stored procedure execution time etc.
• Evaluated the Database Performance of Index tuning with using Database Engine Tuning Advisor to resolve Performance issues.
• Setup and configured SQL Server for other business functions. Index Data Management to determine Defragmentation level; whether to Update Statistics or Rebuild Indexes.
• Scripted the Database Consistency Checks (DBCC), scheduled the scripts to run daily and weekly basis.
• Monitored via SQL modules like Idera Diagnostic manager, Tivoli etc for performance issues like excessive locking, table scans, deadlocks, fragmentation and other bottlenecks.
• Responsible for SQL Server tuning and performance evaluation and optimization and utilized new features like SQL Dynamic Management Views for the same. Also responsible for Query Performance tuning and Optimization.
• Used Visual Source Safe 2008 for version control. Created various Stored Procedures to enforce the business logic.
• Created Database Diagram using Erwin Data Modeler, Data Dictionary Document, Database Installation and Configuration Document and Merge Replication Setup Document.
• Worked closely with development team for performance enhancements, code reviews and provided vital inputs in terms of index optimization, schema structures, data changes, file layouts etc.
• Extracted data from various sources like SQL Server 2005/2008, Oracle, Teradata, .CSV, Excel and Text file from Client servers and through FTP.
• Handled Performance Tuning and Optimization, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located globally.
• The SSIS packages created included a variety of transformations, for example Slowly Changing Dimensions, Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast, and Data Conversion.
• Responsible for identifying and defining Data Source and Data Source views mappings for ETL.
• Developed, deployed and monitored SSIS Packages for new ETL Processes and upgraded the existing DTS packages to SSIS for the on-going ETL Processes.
• Monitored Full/Incremental/Daily Loads and support all scheduled ETL jobs for batch processing.
• Provided primary pager support on rotation basis.

Environment: MS SQL Server 2005/2008, Toad, T-SQL, DTS, Replication, MS Access, Windows 2008 server, Windows NT 4.0,SSIS, LITESPEED, SQL Profiler, SQL Server management Studio.

Confidential, Greenville, SC 2007 Mar-Feb 2009

Database Administrator/ Developer
Confidential, is one of the USA's leading distributors. With nearly $19 billion in annual revenue, US Foods is the 10th largest private company in America. US Foods offers more than 350,000 national brand products and its own "exclusive brand" items, ranging from fresh meats and produce to be prepared and frozen foods. US Food maintains terabytes of information about their product lines and their customers. As part of SQL DBA team my role was to provide database administration services for various product databases and PIM applications.

Responsibilities:

• Involved in Technical decisions for Business requirement, Interaction with Business Analysts, Client team, Development team, Capacity planning and upgrading of SQL Servers.
• Responsible to provide 24x7 DBA & Production support for over 180 SQL Server databases in Production on Clustered Servers.
• Setup and troubleshoot for Active/Passive Clustering in SQL Server 2005 and 2008.
• Set database environment for Application including creation of Scheme, tables, procedures and functions.
• Configured DR solution with Transaction Replication from Distribution Server with multiple Updatable subscriptions.
• Designed and developed ETL processes using SSIS to receive customer files from data warehouses and load them into transaction processing systems.
• Involved in Installation, Configuration and Deployment of SSRS Reports using different topologies
• Performed Database Refresh tasks from production to Development and Staging Servers
• Performed Scheduled backups and restore operations with LiteSpeed 4.5
• Created (with respect to standards) Logins, Users, groups, Roles, Jobs, Alerts, Mails confirmation upon tasks.
• Performed Database consistency checks with DBCC , Defrag, Index tuning and monitored error logs
• Maintained two different databases: Read-only reporting database and Disaster recovery database.
• Performed security tasks like Grant, Revoke permissions for security tasks.
• Involved in auditing and performing the transactions to database and resolve the issues with Performance Monitor and SQL Profiler.
• Involved in developing Stored Procedures, Triggers, and SQL scripts for performing automation tasks.

Environment: SQL Server 2005, SQL Server 2008, Toad, SQL Loader, MS-Access, .Net Framework2.0, HTML, Windows-NT, Windows 2003 Server, LiteSpeed.

Confidential, Orangeburg, SC 2005 May-Mar 2007
Application Analyst (Database Administrator)
The project involves in migrating to Oracle 10g environments, Deployment of new applicationsin oracle related to the financial aid, HR, and payroll. Our support tasks involve basic of planning the environment before the deployment and to the managing and maintenanceinvolving troubleshooting application, Managing and Coordinating various Database related maintenance activities and issues.

Responsibilities:

• Create and maintain various databases for Production, Development and Testing environments using SQL Server 2000.
• Created Tables, Stored Procedures, Views, Triggers, Cursors and Complex Queries on SQL Server 2005/2008.
• Created (with respect to standards) Logins, Users, groups, Roles, Jobs, Alerts, Mails confirmation upon tasks.
• Design and implementation of backup and recovery using RMAN.
• Monitor RMAN Backup batch and resolving issues.
• Databases refresh/cloning using Datapump/export import and cold clone.
• Writing scripts to automate certain jobs like exports and Data Loading.
• Experience working with Product development team for day to day support.

Environment: SQL Server 2000, Enterprise Manager, Oracle 10g, T-SQL, PL/SQL, SQL Developer, SQL plus, Oracle enterprise manager (OEM), Windows 2003, SQL Loader, TOAD, Data Pump

Confidential, Bangalore, INDIA 2001 Jan-Apr 2005
IT Analyst

Project #1: Confidential, Phoenix, AZ 85054, Oct 2004-Jan 2005

Responsibilities:

• Coded SQL/stored procedures/functions/packages using PL/SQL.
• Developed and implemented applications using Java and JSP.
• Interacted with AMEX managers and users.
• Deployed enterprise applications within the Enterprise environment.
• Reviewed the Java coding to maintain standards.
• Tested the application the JUnit.

Environment: Oracle, PL/SQL, Toad, OOA/OOD, MVC, J2EE, Servlets, Java Server Pages (JSP), JavaBeans, JDBC, stateless Session EJBs, HTML, Java Messaging Service (JMS), JavaScript, Web Sphere Application Server, Struts, JUnit, CVS, Design Patters, Java Programming Best Practices, RDMS, Web Sphere Studio Application Developer v5.0, Ant, Unix.

Project #2: Confidential, Philadelphia, PA, Sep 2003-Sep 2004

Responsibilities:

• Coded SQL/stored procedures/functions/packages to retrieve data from oracle database.
• Design tables and classes.
• Data modeling using Master Craft.
• Designed and developed sub processes in Party Management.
• Responsible for full life cycle Java Development within J2EE Applications using Servlets, Java Server Pages (JSP), JavaBeans, and JDBC.
• Developed and deployed applications in Weblogic Application Server.
• Interacted with client to Prepared HLD and LLD documents.
• Involved in Design and development of the Application.
• Involved in Preparation of UTS
• Tested the application using Junit.

Environment: Oracle 9i, PL/SQL, SQL Plus, SQL Developer, MVC, J2EE, Servlets, Java Server Pages (JSP), JavaBeans, Session EJB, JDBC, SQL, HTML, Core Java, JavaScript, Struts, JMS, JUNIT, Core Java, Windows NT, Master craft, UML, Unix, VSS.

Project #3 : Confidential, Auckland, NZ, Jan 2001-Sep 2003

Responsibilities:

• Coded procedures, functions and trigger in PL/SQL.
• Involved with Design and development of Application using java, swing and SQL.
• Data modeling using Master Craft.
• Coded and Tested Client side using Java-swing.
• Developed batch programs to renew the insurance policies using Java 1.2.
• Interacted with clients through telephonic conferences to ascertain requirements and resolve issues.
• Developed and maintained intranet for the team-using HTML.
• Parsed the XML data using DOM parser.

Environment: Oracle 8i, Toad, SQL Plus, PL/SQL, OOA/OOD, MVC, J2EE, Servlets, Swing, JavaBeans, Session EJB, JDBC, SQL, HTML, JMS, Windows NT, Master Craft, UML, Unix, VSS.