SUMMARY:

• Overall 14+ years of experience in MS - SQL Server and Oracle Administration including Design and implementation of Distributed/Replicated Databases, planning/implementing backup/recovery strategies, Disk space management, Memory management and Performance tuning.
• Extensive experience in ETL process by using SSIS (SQL Server Integration Services) and DTS Designer in SQL Server and Oracle environments and creating reports using SSRS (SQL Server Reporting Services)
• Experienced in comparing schemas in different databases using Red Gate software
• Experience in monitoring and tuning multiple databases SQL Server and Oracle databases using MS-SQL server Administration tools (MMC) and Oracle Enterprise Manager
• Experienced in setting up Microsoft Cluster and managing SQL Server 2005/2008/2012 databases in Cluster environment
• Experience in SQL Server stored procedures, views, triggers, UDF’s and configuration of multiple instances, and clusters
• Involved in design and development of SSIS/DTS packages to load data from Oracle, Excel, Access and flat file feeds to SQL Server and vice versa
• Involved in performance tuning of very complex SQL statements and procedures using showplan and iostatic, creating named cache and binding objects
• Expertise in trouble-shooting (handling database corruption, transaction log problems, deadlocks, and Query performance problems)
• Expert in performing database consistency checks (DBCC Commands) and planning and scheduling Backup & Recovery
• Expert in MS SQL Server 2005/2008/2012 Administration, which includes Installation & Configuration on Windows 2000/2003/2008 Server
• Expert in Oracle Administration, which includes Installation & Configuration of Oracle database in stand-alone and RAC environment
• Experienced in creating ASM instance and migrating from OCF2 to ASM on Oracle 10g/11g
• Designed High Availability Databases with Oracle Standby Database, RAC
• Expert in Disaster recovery using RMAN and GALAXY Backup Systems

TECHNICAL EXPERTISE:

O/S: DOS 6.1, Windows XP/2000/2003, HP UNIX, Linux Red Hat Enterprise

Hardware: IBM PC/AT 486, Pentium, Pentium II & III

Languages: SQL, PL/SQL, HTML, DHTML, JAVA Script, VB Script, Visual Basic 6.0, Computer Graphics with OpenGL

Applications: Office 2003/2007, FTP, XML, TCP/IP

Tools: RMAN, Oracle Enterprise Manager, Visio, ERwin 3.52, Quest TOAD, Quest Schema Manager, Import & Export, Spotlight, SQL Lab Vision, ASMCMD, SQL Server Migration Assistant (SSMA 4.0), SQL Backtrack (BMC Software), DB Artisan, SQL*Loader, Reporting Services (SSRS), Red Gate, SharePoint 2007/2010, Power Shell Scripting

RDBMS: MS SQL Server (2014, 2012, 2008R2, 2008, 2005, 2000, 7.0, 6.5), Oracle 10g/9i/8i/8, MS Access 2000/2003

WORK EXPERIENCE:

Confidential, Washington, DC

Senior DBA Architect

• Prepares system requirements, source data analysis and process analyses documentation and design documentation throughout the database creation and implementation
• Identifies improvement and technological solutions for decision support services, data analytics services and data management system enhancements
• Investigates and evaluates new data analytics algorithms and technologies to support investigative data analysis requirements
• Follows processes and procedures to identify and implement process improvements
• Participates in and conducts data extraction, transformation and load code, preprocessing and post processing scripts peer reviews
• Effectively and actively communicates with the engineering team, management, and the IRS Customer
• Setup database mirroring using Always On (AG) feature of SQL Server 2012
• Experience in setup the SQL Server Clustering (2008,2012 and 2016)
• Experience in cloning the Production databases to UAT, QA, and DEV environments
• Implement policies for database migrations and consolidation
• Experience in performance tuning and database capacity planning
• Participate and implemented disaster recovery processes
• Experience in SQL Server Transparent Data Encryption (TDE)
• Experience in ETL process using Informatica and SSIS tools
• Experience in writing reports using SSRS
• Responsible to recommend and strategies to application owners on how to improve performace and scalability of their database components
• Provide architectural guidance on strategies to improve operations and monitoring of current and future implementations

Confidential, Springfield, VA

Senior DBA Developer

• Analyze and define the logical and physical database structure on the project requirements
• Establish, maintain, and control the project data model and data dictionary
• Provide technical guidance to system and application programmers
• Develop, document, and enforce standards, security procedures and controls for access to ensure the integrity of database system
• Design, implement, and periodically test the backup and recovery procedures
• Direct and participate in the conceptual database design and specifications
• Perform database administration activities including but not limited to installation, configuration, backup and maintenance of the databases in multiple environments
• Perform database tuning activities using different approaches such as reviewing indexing strategies, database and server configurations
• Perform database tuning activities using different approaches such as reviewing indexing strategies, database and server configurations
• Ensure the reliability, serviceability, and maintainability of the system with demonstrable accuracy, privacy, and security
• Develop test plans and test data for database systems and support software.
• Serve as a primary point of contact for hardware, software and database upgrades, removing and servicing user accounts on system platform and in all databases
• Contribute in the development knowledge base
• Participate and contribute in process improvement activities at the project and corporate level

Confidential, Herndon, VA

Senior DBA Consultant

• Responsible to design and implement SQL 2005/2008/2008- R2 Servers running on 64-bit windows servers in cluster environment in DEV, Testing, and PROD
• Responsible to manage SQL Server 2008-R2 databases for SharePoint 2007/2010 environment
• Responsible to optimize SharePoint 2007/2010 databases for better performance
• Interact with system administrators to allocate storage for SharePoint databases
• Familiar with SharePoint 2007/2010 site creation, manage user permissions, SharePoint Central Administrator tool
• Responsible to configure different SharePoint 2010 services and creation of SharePoint databases
• Helped migration/upgrade SharePoint from 2007 to 2010
• Interact with users to gather business requirements and build solutions based on SQL Server technologies
• Responsible to review code (stored procedures, functions, etc), approve and move into Production environment
• Responsible to review database log files to identify risks and issues. Escalate risks and issues to management and recommend solutions
• Follow pre-defined SDLC process
• Responsible to enforce database standards for coding (stored procedures, functions, triggers etc)
• Responsible to create and maintain complex SSIS/DTS packages
• Involved in taking BACKUPS and restoring process of Development, Testing and Production Databases
• Involve in creating Disaster Recovery process for SQL Server 2005/2008
• Involve in creating database mirroring for disaster recovery process and maximum uptime for SQL Server 2005/2008 databases
• Experienced on creating, migrating, and upgrading DTS packages from SQL 2000 to SQL 2005 SSIS/DTS packages
• Involved in doing Capacity planning for business critical applications running on SQL Server 2005
• Build a process to load data using DTS and SSIS packages
• Responsible to install SQL Server software and apply patches/service packs as needed
• Managing and scheduling daily jobs relating to data transfers, backup and recovery, transaction log dumps on SQL Server
• Responsible for implementation and administration of SQL Server Databases for maximum uptime

Confidential, Washington, DC

Senior DBA Consultant

• Responsible to design and implement SQL 2005 Servers running on 64-bit windows servers in cluster environment in DEV, Testing, and PROD
• Involve in creating Disaster Recovery process for SQL Server 2005
• Experienced in migrating Oracle database to SQL Server 2005 using SSMA 4.0 tool
• After mapping schemas (from Oracle to SQL Server), install SQL Server and create databases based on schema requirements
• Worked with developers to map the objects from Oracle to SQL Server 2005 migration
• Involve in creating database mirroring for disaster recovery process and maximum uptime for SQL Server 2005 databases
• Experienced on creating, migrating, and upgrading DTS packages from SQL 2000 to SQL 2005 SSIS packages
• Involved in doing Capacity planning for business critical applications running on SQL Server 2005
• Build a process to load data using DTS and SSIS packages
• Build reports using SQL Server Reporting Services 2005 (SSRS)
• Involved in taking BACKUPS and restoring process of Development, Testing and Production Databases
• Responsible to install SQL Server software and apply patches/service packs as needed
• Managing and scheduling daily jobs relating to data transfers, backup and recovery, transaction log dumps on SQL Server
• Responsible for implementation and administration of SQL Server Databases for maximum uptime
• Provide 24 hours on-call support for SQL Server databases

Confidential, Washington, DC

Senior DBA Consultant

• Responsible to manage SQL 2005 Servers running on 64-bit windows servers in cluster environment in DEV, Testing, and PROD
• Involve in creating Disaster Recovery process for SQL Server 2005
• Involve in creating database mirroring for disaster recovery process and maximum uptime for SQL Server 2005 databases
• Experienced on creating, migrating, and upgrading DTS packages from SQL 2000 to SQL 2005 SSIS packages
• Experienced in managing SQL Server databases in Cluster environment
• Involved in doing Capacity planning for business critical applications running on SQL Server 2005
• Build table partitioning for big tables to improve performance
• Build a process to load data using DTS and SSIS packages
• Build reports using SQL Server Reporting Services 2005 (SSRS)
• Normalization, data modeling, data transformations, mapping, and data mining
• Involved in taking BACKUPS and restoring process of Development, Testing and Production Databases
• Backup and restore databases utilizing maintenance plans, T-SQL, or third party tools BackupExec
• Responsible to install SQL Server software and apply patches/service packs as needed
• Responsible to work with business analysts, developers, and infrastructure technologies to meet the organizations goals
• Prepare change control documents for each job/package developed for promoting from Test to QC, and to Production
• Determine database movement strategies across servers using Red-Gate software
• Help analyze performance issues on existing systems and aid developer to optimize stored procedures
• Managing and scheduling daily jobs relating to data transfers, backup and recovery, transaction log dumps on SQL Server
• Responsible for implementation and administration of SQL Server Databases for maximum uptime
• Provide 24 hours on-call support for SQL Server databases

Confidential, Jacksonville, FL

Functional DBA Team Lead

• Responsible to manage SQL 2005 Servers running on 64-bit windows servers in cluster environment in DEV, QA, and PROD
• Experienced enough migrating/upgrading SQL Server database from SQL 2000 to SQL 2005
• Experienced in migrating Oracle database to SQL Server 2005 using SSMA 4.0 tool
• Worked with developers to map the objects from Oracle to SQL Server 2005 migration
• Experienced on migrating/upgrading DTS packages from SQL 2000 to SQL 2005 SSIS packages
• Experienced in managing SQL Server databases in Cluster environment
• Involved in doing Capacity planning for DW and other projects
• Build table partitioning for big tables to improve performance
• Build a process to load data to Data Warehouse using DTS and SSIS packages
• Build reports using SQL Server Reporting Services 2005 (SSRS)
• Normalization, data modeling, data transformations, mapping, and data mining
• Involved in taking BACKUPS and restoring process of Development, QA and Production Databases
• Backup and restore databases (size up to 1 TB) utilizing maintenance plans, T-SQL, or third party tools Commvault (similar to LiteSpeed)
• Responsible to install SQL Server software and apply patches/service packs as needed
• Responsible to work with business analysts, developers, and infrastructure technologies to meet the organizations goals
• Prepare change control documents for each job/package developed for promoting from Test to QC, and to Production
• Determine database movement strategies across servers using Red-Gate software
• Reverse engineer to draft ERD of databases used by a third party application ERWIN/VISIO
• Help analyze performance issues on existing systems and aid developer to optimize stored procedures
• Manage database security including encryption, server/database logins and roles
• Used SQL Profiler extensively to monitor the performance of the application/data migration and databases
• Design, implement, and maintain Oracle and SQL Server Databases
• Managing and scheduling daily jobs relating to data transfers, backup and recovery, transaction log dumps on both Oracle and SQL Server
• Responsible for implementation and administration of SQL Server/Oracle Databases for maximum uptime
• Involve in creating Disaster Recovery process for both SQL Server and Oracle databases
• Involved in complex code reviews and code walkthroughs of various projects
• Provide 24 hours on-call support for both SQL Server and Oracle production databases
• Experienced in creating, implementing, and managing transparent data encryption in Oracle databases
• Experienced in creating and managing Oracle databases on 2 node RAC environment
• Experienced in creating and managing ASM instances in RAC and stand alone environments