SUMMARY:

• Over 9 years of IT experience in handling various enterprise projects from Client - Server technologies to N-tier Applications.
• Experienced in analysis, design, development, troubleshooting and maintenance of Data warehouse and OLTP applications.
• Expertise in installing, configuring, monitoring, upgrade, partitioning and tune SQL Server 2000/ 2005/2008/2008 R2/2012, SSIS, SSAS and SSRS servers.
• Hands on experience in Installation, configuration, administration and Monitoring Oracle 10g/11g database server and MYSQL 5.0/5.1.
• Expertise in Analysis, designing and implementing Disaster recovery strategies and solutions.
• Expertise in designing, configuring, monitoring, troubleshooting and quick issue resolutions and solutions to MS-SQL Server High availability methods such as Log shipping, Replication (Snapshot, Transactional, Merge), Mirroring and clustering.
• Hands on experience in designing and develop data storage and partitions, archive, purge and configuring and maintaining Policy management, database mail, file stream etc.
• Extensively worked on storage and with system administrators to allocate and configure Instances.
• Expert in performing and monitoring database growth, health and consistency checks, maintenance plans, planning and scheduling Backup & Recovery etc.
• Monitored and tuned all aspects of SQL Server infrastructure like Disk, CPU, Memory, SQL Code etc., by using Profiler, Dynamic management views, and SCOM tools.
• Expertise in Analysis, design, configuring Operational automation tasks.
• Expertise in debugging and troubleshooting of database issues and SQL, T-SQL and PL-SQL code issues.
• Hands on experience in Data extractions to SQL Server from other data sources and performed Data comparison, Data validation, Data mining, Data profiling etc.
• Hands on experience in Database designing, Reverse engineering and forward engineering of the DB.
• Hands on experience in designing and development of reports such as Tabular, Matrix, Sub-reports and Drill down reports using Reporting services.
• Hands on experience in implementing, configuring and monitoring change data capture to push data to secondary servers.
• Hands on experience in configuring and monitoring application service clustering and creation of operational automation tasks.
• Expert in Tuning Procedures and queries for maximum performance.
• Expert in writing T-SQL statements for creating tables, indexes and constraints.
• Involved in performance tuning of very complex SQL statements and procedures using SQL Profiler, showplan and iostatic.
• Hands on experience with Migration of database from Oracle to SQL Server.
• Hands on experience in configuring linked server from Oracle - SQL Server and SQL Server - SQL Server.
• Expertise in trouble-shooting (handling database issues, corruption, transaction log problems, system database issues, Query performance problems).
• Experience in monitoring and tuning multiple databases using MS-SQL server Administration tools (MMC) and other 3rd party tools.
• Extensive experience on testing Applications & QA Methodologies.
• Experience of creating SSAS cube, dimensions and OLAP based reports.
• Expertise in data conversion from various data sources to Sqlserver and Oracle.
• Hands on experience in Backups and restores, Disaster Recovery process and moving parts of table data in oracle instances using Data pump and RMAN.
• Hands on experience in analysis, designing of the databases and writing stored procedures, Functions, Queries, Dynamic queries, Triggers & Cursors, configuring replication methods etc. in SQL Server/Oracle/MYSQL.
• Hands on experience in working as team player in resolving issues, documentation, KB articles, s etc.
• Hands on experience in Incident management, Problem management, change and release management.
• Expertise in Users and role management in SQL Server, Oracle and MYSQL servers.

TECHNICAL SKILLS:

Software/Hardware: Microsoft SQL Server 2000/ 2005/2008/2008 -R2/2012, Oracle9i/10g/11g, MYSQL5.0/5.1, PostGre7.0,TOAD, PL/SQL Developer, MS-ACCESS 2000, Win XP/ 2000/2003/2008/ NT, UNIX, T-SQL, SQL* PLUS, PL-SQL, DTS, IIS, SQL Server Reporting Services(SSRS), SQL Server Integration services(SSIS), SQL Server Analysis services(SSAS), Microsoft Visual SourceSafe(VSS), Extraction Transformation and Loading (ETL) using DTS, SSIS Packages, Bulk Insert, BCP, Informatica, Jasper Reports, Cognos Reports, ERWIN, VISIO, Toad Data Modeler, MYSQL Workbench, Aqua Data Studio ER Modeler, VSS,VERITAS, Lite Speed, SQLSafe, SQLIO, SCOM, SCPM and ITSM, SQLDiag, PAL, Perfmon, WACA, Fiddler, Server Health Check Tool.

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

SQL DBA

Responsibilities:

• Involved in Analysis, design, development, troubleshooting and maintenance of Data warehouse and OLTP application environments.
• Installed configured, upgraded and monitored SQL Server 2000, 2005, 2008R2 and 2012 database server, reporting server and applied patches to production and nonproduction environments.
• Worked on IM and RFC as per the defined SLA, also worked with the team member to meet the dead lines
• Monitoring, troubleshooting and fixing the SCOM alerts of database and server issues.
• Worked on daily production support activities.
• Involved in Day-to-day activities such as Agent Jobs, Backups and Recovery, Services, Index, Database growth, health and consistency check, Data maintenance (partitioning, archiving and purging), problem management, Incident management, Security maintenance etc.
• Involved in designing, configuring, monitoring and troubleshooting replication methodologies, log shipping and mirroring on critical databases issues.
• Monitor and tune all aspects of SQL Server infrastructure like Disk, CPU, Memory, SQL Code etc., by using SQLIO, Perfmon, Profiler, Dynamic management views etc.
• Implemented and configured Backup and recovery process using maintenance plans for all database server included production, dev, devbuild, stage and test etc.,
• Created Operational automation code for daily/weekly database maintenance tasks such as database health and status check, database consistency maintenance, index maintenance,, long running queries, blocking and locking, update stats, monitoring database and log file space and growth, monitoring disk space, failed logins, errors, finding database Logshipping status, mirroring database status, replication agent status etc.
• Created PDC upon approval along with rollback scripts for Production data change.
• Designed, Implemented, configured and monitored Disaster recovery process to MC servers using Log shipping methodology.
• Created SSIS packages upon requirement and migrated existing DTS to SSIS packages.
• Worked on debugging and troubleshooting the database issues and code issues.
• Worked on developing SSRS and Excel reports based on business requirement.
• Performed Performance Tuning of the database, Stored Procedures and SQL queries upon requirement.
• Designed and developed SSIS packages for data extraction, data comparison and validation, data cleansing, data mining, pivoting etc. from multiple data sources and generate excel reports upon requirement.
• Configured basic Sqlserver Policy management across multiple servers and instances as per organization standards.
• Installation and configuration of Oracle 10g database server, creating instances and user objects, Backup and restore procedures, table space maintenance and Data refresh or export and import of databases for dev and test environments etc.
• Written PLSQL code and created stored procedures, functions in Oracle.
• Created stored procedures, functions, views, triggers, replication code etc.
• Worked on version control with VSS to store and maintain the database code, Operational code and changes and HPSM for ticketing.
• Manage SQL Server security, application users, assist developers and users for access issues.
• Worked on the documentation of database, process and database issues.
• Security Administration: creation of users, Roles and granting appropriate privileges.

Environment: SQL, TSQL, PLSQL, SQL Server 2000/ 2005/2008/2008 R2,2012, Oracle 10g, Windows 2003/2008, SSIS, SSRS, SSAS, Active Directory, Excel 2010, VSS, HPSM

Confidential, Austin, TX

SQL DBA

Responsibilities:

• Involved in Analysis, design, development, troubleshooting and maintenance of Data warehouse and OLTP application environments.
• Installed, configured, upgraded and monitored SQL Server 2005, 2008R2 and 2012 database server, reporting server and applied patches to it on dev, devbuild, stage, test and production environments.
• Migrated Data warehouse server from SQL Server R2 and 2008R2- 2012.
• Migrated reporting server databases from SQL server 2005 to SQL server 2008R2.
• Involved in In-place SQL server upgrade from 2008R2 to SQL server 2012.
• Involved in Day-to-day activities such as Agent Jobs, Backups and Recovery, Services, Index, Database growth, health and consistency check, Data maintenance (partitioning, archiving and purging), problem management, Incident management, Security maintenance etc.
• Involved in designing, configuring, monitoring and troubleshooting replication methodologies, log shipping and mirroring on critical databases issues.
• Monitor and tune all aspects of SQL Server infrastructure like Disk, CPU, Memory, SQL Code etc., by using SQLIO, Perfmon, Profiler, Dynamic management views etc.
• Implemented and configured Backup and recovery process using maintenance plans for all database server included production, dev, devbuild, stage and test etc.,
• Created Operational automation code for daily/weekly database maintenance tasks such as database health and status check, database consistency maintenance, index maintenance,, long running queries, blocking and locking, update stats, monitoring database and log file space and growth, monitoring disk space, failed logins, errors, finding database Logshipping status, mirroring database status, replication agent status etc.
• Created PDC upon approval along with rollback scripts for Production data change.
• Designed, Implemented, configured and monitored Disaster recovery process to Data warehouse using Logshipping methodology.
• Partitioned the huge Fact tables which have more than trillion records.
• Analyzed, Implemented and configured daily, monthly and yearly partitions on requirement and optimized existing stored procedures to retrieve data from specific partitions based on boundary values and partition numbers.
• Implemented and configured automation code for Data Archival process of some huge fact tables using partition switch OUT method.
• Implemented and configured automation code to summarize huge fact table (days) data into month data and store back into the partition table using partition switch IN process.
• Created SSIS packages upon requirement and migrated existing DTS to SSIS packages.
• Worked on the creation of the cubes based on requirement, changed the data source and reprocess the existing cubes.
• Involved in verifying all the reports and its queries like SQL, Dynamic SQL and stored procedures, also found the old data sources used by reports from the backend using queries and changed the code and data source accordingly.
• Worked on debugging and troubleshooting the database issues and code issues.
• Performed Performance Tuning of the database, Stored Procedures and SQL queries upon requirement.
• Designed and developed SSIS packages for data extraction, data comparison and validation, data cleansing, data mining, pivoting etc. from multiple data sources and generate excel reports upon requirement.
• Configured basic Sqlserver Policy management across multiple servers and instances as per organization standards.
• Installation and configuration of Oracle 10g database server, creating instances and user objects, Backup and restore procedures, table space maintenance and Data refresh or export and import of databases for dev and test environments etc.
• Written PLSQL code and created stored procedures, functions in Oracle.
• Created stored procedures, functions, views, triggers, replication code etc.
• Worked on version control with VSS to store and maintain the database code, Operational code and changes and Fogbugz for bug tracking.
• Manage SQL Server security, application users, assist developers and users for access issues.
• Worked on the documentation of database, process and database issues.
• Security Administration: creation of users, Roles and granting appropriate privileges.

Environment: SQL, TSQL, PLSQL, SQL Server 2000/ 2005/2008/2008 R2, Oracle 10g, Windows 2003/2008, SSIS, SSRS, SSAS, Active Directory, Dot net and Excel 2010, VSS, Fogbugz.

Confidential, Redmond, WA

Project Lead

Responsibilities:

• Involved in Analysis, design, development, troubleshooting and maintenance of Data warehouse and OLTP application environments.
• Involved in Install, configure, monitor, upgrade, patch and tune SQL Server 2005, 2008, 2008R, 2012, SSIS and reporting servers.
• Worked with storage team and system administrators to allocate and configure Instances.
• Worked on debugging and troubleshooting the database issues and code issues.
• Performed Performance Tuning of the database, Stored Procedures and SQL queries.
• Designed and implemented Logical and physical database design upon requirement, also the patching the critical servers\instances.
• Involved in designing, configuring, monitoring and troubleshooting replication methodologies, log shipping and mirroring on critical databases and quickly resolving issues.
• Created PDC upon approval along with rollback scripts using product studio.
• Involved in Day-to-day activities such as Agent Jobs, Backups and Recovery, Services, Index, Database growth, health and consistency check, Data maintenance (partitioning, archiving and purging), issue\ problem maintenance and management, Incident management, Security maintenance etc.
• Monitor and tune all aspects of SQL Server infrastructure like Disk, CPU, Memory, SQL Code etc., by using Perfmon, Profiler, Dynamic management views, and SCOM tools.
• Analyzed, designed, configured and monitored the Sqlserver Policy management across multiple servers and instances.
• Involved and implemented the Disaster recovery process to the critical databases and Instances as per MSFT standards.
• Designed, configured and monitored change data capture with TSQL to push the application data to the Reporting database.
• Configured SQL Server clustering and application services clustering.
• Managed internal and external MS SQL database security.
• Created stored procedures, functions, views, triggers, replication code, reports etc.
• Worked on SCOM to create management packs to monitor the SQL Server, application, IIS, windows issues, fix them proactively and closed the incidents with in SLA.
• Designed and implemented Operational automation tasks.
• Worked on version control with VSS and maintained the database code and Windows scripting code.
• Designed and developed SSIS packages for data extraction, data comparison and validation, data mining etc. from multiple data sources and generate excel reports and SSRS reports.
• Involved and worked with the Change management, Release management for the smooth releases and of application\server\db installation or db patch\upgrade.
• Worked on PDC and DCR upon requirement.
• Designed, developed reports using Sqlserver Reporting services.
• Manage SQL Server security, application users, assist developers and users for access issues.
• Worked as team player in resolving issues, documentation, KB articles etc.
• Security Administration: creation of users, Roles and granting appropriate privileges.

Environment: SQL, TSQL, SQL Server 2005/2008/2008 R2/2012, Windows 2003/2008, SSIS, SSRS, IIS, Forefront Identity Management (FIM), Active Directory, Dot net, Power shell and Excel 2007\2010, Product studio, ITSM.

Confidential, Matawan, NJ

Sr. Database Administrator

Responsibilities:

• Installation and Configuration of SQL Server 2000, 2005 and 2008 Enterprise Edition on Win2003 server and applied patches.
• Involved in re-engineering of the product and as well as database.
• Worked with the team to apply the database patches to the physician’s application and DB, also identified and resolved issues occurred on physician’s servers.
• Involved in Performance tuning of the DB.
• Involved in the development and managing of server manager tool for the creation of default databases and physician database used by the application also for monitoring the database replication.
• Involved in DB Design and Development of the VB.net and Database Traceability tool.
• Involved and implemented operational automation tasks for Medical billing i.e. Payments and Posting.
• Involved in DB designing, written SP’s, monitoring, administration and also generated reports for a product called GSS AR caller, used by our AR callers i.e. BPO TEAM.
• Involved in CCHIT of the product.
• Involved in the analysis of ICD9 to ICD10 code migrations and implementing in the product database.
• Implement, configured, monitoring and troubleshooting Merge Replication on central server which is configured to many stand by databases i.e. from Physician’s database to the Data center database and vice versa.
• Configured Log shipping of the application database for the reporting purposes.
• Designed and developed SSIS packages for data extraction, data mining, data validation etc. from multiple data sources.
• Involved in the Migration of DB from Oracle10g to SQLSERVER.
• Installed and configured MySQL server and configured master- slave replication.
• Designed and implemented Logical and physical database design of the new product database on MySQL and SQL Server, created tables, stored procedures, functions, and dynamic SQL code based on requirement.
• Created SSIS package, batch code and scheduled for the data flow from MySQL to SQL Server.
• Installation, configuration, managing of Oracle10g server in prod, dev, devbuild and test environments and import the database and user objects.
• Creation of users, roles and assigning permissions on objects.
• Backup and recovery process of oracle database objects.
• Involved and developing reports using SQL Server reporting services.
• Writing more effective SQL / T-SQL code based on requirement.
• Involved in Day-to-day maintenance and management activities like DB growth, health, consistency checks, Agent Jobs maintenance, Index maintenance, monitoring, performance tuning, and troubleshooting issues.
• Security Administration: creation of users, Roles and granting appropriate privileges.
• Wrote stored procedures, functions, triggers, packages in Oracle.

Environment: SQL, TSQL, SQL Server 2000/ 2005/2008/2008 R2, Oracle 11g, PL/SQL, Mysql 5.0DTS, Dot net, Windows 2003/2008, PL/SQL Developer, IIS, SQL server Reporting services, SQL Server Integration services and Excel 2007.

Confidential, Hooksett, NH

Sr. Database Administrator

Responsibilities:

• Involved in Analysis, Design, Development of functional requirements and OLTP database environment requirements.
• Installation of SQL SERVER 2008 Enterprise Edition on Win2003 server, applied patches, monitoring and troubleshooting.
• Designed the database based on requirement.
• Default and post upgrades leasing data extractions from excel to the database, data mining, Data comparison etc using SSIS package and configured in setup files for further installations.
• Installation, configuration, managing of Oracle 10g server.
• Creation of users, roles and assigning permissions on objects.
• Backup and recovery process of oracle database objects.
• Created a Linked server for distributed queries (Oracle to SQL Server).
• Created and enabled file stream on required tables for storing large files in a separate location.
• Configured and monitored Transactional Replication between primary database and stand by database, i.e. standby database is used for JASPER server reports.
• Involved in developing JASPER reports (General and Adhoc reports).
• Writing more effective SQL / T-SQL code based on requirement.
• Day-to-day activities such as database and server maintenance and management, Agent job maintenance, health checks, Issue management, monitoring, performance tuning and troubleshooting etc.
• Security Administration: creation of users, Roles and granting appropriate privileges.
• Configured SQL Server 2008 clustered environment for High availability of the database server.

Environment: SQL, T-SQL, SQL Server 2005/2008, Oracle 10G, Windows 2008, Dot net, Excel, Jasper Reports, SQL Server Integration Services.

Confidential

Database Administrator

Responsibilities:

• Enhanced website with more features of data driven content management and improved the usability, scope of Administrative controls, user controls, look-and-feel of the portal. Enhanced website for better navigation & improve content management on Oracle and SQL servers.

Environment: SQL, T-SQL, PL-SQL, SQL Server 2005/2008, Oracle 10G, Windows 2008, Java, SSMA, SQL Server Integration Services, SwissSQL.

Confidential

Database Administrator

Responsibilities:

• Build a secure social network portal / gateway for children (ages 4-18), free of the usual online pitfalls with embedded parental controls.
• Dolphin Digital Media will allow the members to customize their basic iDolphin portal, and allow them to add different portlets, widgets, customized themes, etc. iDolphin is a safe portal for Internet surfing and social networking free from Internet predators. IDolphin Secure allows parents to control children go on the Internet, whom they interact with and what they do.

Environment: SQL, T-SQL, SQL Server 2005, Mysql 5.0, Windows 2008, Java

Confidential

Database Administrator

Responsibilities:

• Designed & developed database for “Suggestion & Notification System “application for Confidential, Dubai. Migration of the database from Oracle 10g to SQL Server 2008. This application is meant for Dubai residents to post suggestions on Confidential Portal. Implemented role based security & data extraction from various sources.

Environment: SQL, T-SQL, SQL Server 2005/2008, Oracle 10G, Windows 2008, Java,SSMA

Confidential

Software Engineer

Responsibilities:

• Involved in database activities and ETL activities such as Sqlserver, Oracle and MySQL Administration, Installation, Configuration, Security Management and Monitoring, troubleshooting issues. Planning and scheduling Backup and Recovery. Configured SAC between instances for connectivity between databases and applications.
• Involved in design and development of data work flows based on the business requirements using Informatica. Wrote stored procedures, function, views and triggers. Involved in logical and physical database design based on business requirement. Enrolling users and maintaining system security. Developed and implemented backup strategies using Maintenance Plans and Day- to-Day maintenance activities.

Environment: SQL, T-SQL, PL-SQL, SQL Server 2005/2008, Oracle 10G, Mysql 5.0, Windows 2000\ 2003, Java, Informatica, SSIS