SUMMARY

• Expertise in Oracle 11g, ASM, RAC, OEM, PL/SQL, Data Guard, RMAN and Shell Script
• Knowledge of data flow diagrams, data dictionary techniques, CASE tools, Entity - relation modeling and design techniques.
• Knowledge of database normalization theory, Oracle patching methodologies, and data modeling techniques.
• Good Understanding of disk hardware architecture, database design, cache controllers, and disk load balancing for UNIX and Windows Operating Systems.
• SQL*Plus, Enterprise Manager, Grid Control, SQL Loader, ERwin, RMAN, AWR, Scheduler, Data Pump, RAC, Partitioning
• Active Data Guard, UNIX Shell Scripting, ASM, Data Archiving, TOAD, MobaxTerm, SecureCRT.

TECHNICAL SKILLS

OPERATING SYSTEMS: UNIX - Sun Solaris, HP-UX, Linux, Windows Operating Systems (2012/2008/2003 Server)ORACLE DATABASE/APPLICATIONS

Oracle: 10G. Oracle 11Gr1 & Oracle 11GR2, Oracle Grid Control/OEM, Oracle Statspack, AWR, ADDM, DBArtisan, MS-Visio, RMAN,Quest Tools-Toad, Spotlight, SQL Navigator.

MICROSOFT: SQL SERVER DATABASE/TOOLS

MS SQL: Server 2014/2012/2008 R2/2005, SSIS, SQL Agent, Configuration Manager, SQL Profiler, Visual Studio 2008 2012.

LANGUAGES: SQL, T-SQL, PLSQL, UNIX Shell

PROFESSIONAL EXPERIENCE

Oracle/SQL SERVER DBA

Confidential, Douglasville, GA

Responsibilities:

• Oracle DBA duties involving development and production support such as installations, configurations, backup/restore & recovery, database monitoring & operating system configurations, database performance tuning, assisting in the logical/physical database design, applications profiling, tuning queries and providing support to developers.
• Performing Hot/Cold backups of the database through RMAN or User Managed method.
• Used Oracle 10g AWR & ADDM to monitor database activities and performance tuning.
• Cloning/replicating/refreshing production databases to test/ development environments using RMAN scripts.
• Designed, configured and maintained backup and recovery policies including RMAN
• Upgraded Databases from 10g to 11g and applied patches as per requirement.
• Involved in discussions with the management regarding the advantages/disadvantages and upgrade plans.
• Working with other IT professionals for database designs and reviews; troubleshooting database issues, and deploying timely fixes; maintaining regular and proactive database patches, updates and performance enhancement.
• User creation and implemented Security administration by creating roles, views and granting the necessary system and object privileges for users.
• Managing of Tablespace for different user by granting quota on Default & Temporary Table spaces.
• Installed and configured Oracle Data-Guard on standby servers to online transfer and apply archived log files to keep standby server in sync with primary database.
• Proactively monitoring and tuning of database performance using AWR, ADDM, statspack, DB - Artisan, Quest Central, Autotrace, Explan Plan, and TK PROF. Tune the various components of the database - Memory, CPU, I/O, and SQL statements.
• Identified, resolved, and provided recommendations to various instances of performance problems which include Database performance problems, I/O hardware performance problems etc.

Microsoft SQL Serve

Confidential

Responsibilities

• Creating and managing schema objects such as Tables, Views, Indexes and referential integrity andconverting them into technical specifications.
• Created Maintenance Plans to checking database integrity, rebuilding indexes and updating statistics
• Backup and Recovery of Production Databases and Tuning them for better Performance.
• Extensively worked on Profiler, Perfmon Counters, DMVs, DMFs and DTA to tune the databases, serversand query tuning.
• Worked on high availability SQL Server solutions, including Log shipping, Mirroring and SQL Server
• Clustering.
• Creating new Databases and Migrated SQL Server 2008R2 databases to SQL server 2012 by using Backup-Restore, Detach-Attach, and Management Studio Wizards and custom scripts.
• Transformed data from various data sources using OLE DB connection by creating various SSIS packages.
• Planned, Installed and configured Third-Party tools like Diagnostic manager, Spotlight
• Implementation of Backup, Re-index, DB Shrink, Log Shipping and other database maintenance jobs through
• Configured database mail to inform corresponding DBA basis on each Job Status.
• Creating and Modifying Tables, T-SQL Stored Procedures, Views, Indexes, User-defined Functions, and
• Performed Backup and recovery Automation of Backups using maintenance plans.
• Involved in troubleshooting front end applications designed in ASP.NET for connectivity issues and backend
• Used SSIS to populate data from various data sources, creating packages for different data loading operations
• Configured Monitored Supported and Troubleshooting of Database Mirroring and Log Shipping for multipledatabases on Geo-graphically separated cluster environments to provide High Availability and DisasterRecovery. Support and troubleshooting for Transactional replication.
• Designed and implemented backup plans as per the data- retention policy outlined in the BRD (Business

Oracle DBA

Confidential, City of Chicago Chicago, IL

Responsibilities:

• Performed capacity planning, design, and installation, configuration and deployment of Oracle 11g database within the computing environment.
• Migration of standalone databases to RAC and ASM.
• Installation and management of RAC multi-node cluster.
• Creation and management of ASM instance, disk groups, and disks.
• Perform database upgrades, migrations and installation CPU and on-off patches as needed.
• Perform reorganization database structure as needed as well as redistrubion of datafiles to improve I/O performance.
• Design, deployment, and management of enterprise Backup and Recovery strategies, using RMAN, Import/Export, Data Pump. Monitor and resolve backup failures, perform database/data recoverability testing quarterly, using RMAN.
• Creation and management of database objects - tables, Indexes, views, synonyms, snapshots, materialized views, stored procedures, triggers, table partitions and partitioned indexes.
• Configuration of Oracle High Available options using Data Guard and Snapshot Replication from primary to remote sites for disaster recovery and data distribution.
• Provide 24/7 database support toproduction application users as well as application developers and testers.
• Manage enterprise database security in compliance with SOX standards. Setup database audit, data encryption, create users, roles with appropriate privileges.
• Experienced writing Oracle PLSQL programs for database related management.
• Perform database refreshes from production to test/development as well as performing change/code deployment to production accordance with enterprise change management process.
• Work with software vendors and Oracle support to ensure all database and application related issues are resolve timely and efficiently.
• Work with Systems Administrator in database/application problems troubleshooting and resolution.
• Monitoring and management of database storage and tablespace space utilization.
• Ability to multi task - Manage projects along side production support.
• Supervise and mentor Junior DBA’s.
• Represent DBA group in weekly change management meetings and various project meetings

Oracle/M SQL SERVER DBA

Confidential

Responsibilities:

• Installed, configured Oracle 10G and 11gr2 on Linux, Sun Solaris and HP servers.
• Migration of standalone databases to RAC and ASM.
• Installation and management of 2-node RAC cluster on Linux.
• Implementation of physical database and database changes per logical design design
• Performed upgrades and migrated several oracle 9i databases to 10G
• Created, procedures, functions, packages, triggers, views, tables, indexes, table partitions, Partitioned indexes; synonyms and db links.
• Performance tuning and optimization of Oracle applications and databases (Database Buffer cache, Library catch, Dictionary catch
• SQL area,sql statement tuning, I/O and CPU) using statspack, AWR reports, TKprof, SQL Trace, explain Plan. identify problems and implement solutions; ensure the database is running at optimum speed and efficiency.
• Interface with vendors, project implementation groups & end users for efficient service delivery..
• Performed data loading using SQL Loader, Export/Import, Data Pump.
• Managed database security - created users, roles, grating and revoking of privileges as required.
• Managing database storage and database space utlizations
• Interface with vendors, project implementation groups & end users.
• Attend DBA group in weekly change management meeting, where all planned production changes is approved prior to deployment.

Microsoft SQL SERVER

Confidential

Responsibilities:

• Managed multiple instances of SQL Server in Virtual and Physical environments with 32 64 bit environments
• Managed Production environments and participated in on call 24 7 support
• Did heavy duty Migration Upgrades from lower version of SQL Server to SQL Server 2008 R2
• Installed configured SQL Server in Virtual Environments using VMWare.
• Installed SQL Server 2008 R2 2008 and SQL Server 2005 on windows 2008 and 2003 servers, appliedservice packs and security fix for all servers.
• Exclusive Knowledge of Database security including creation of roles login user accounts and having good
• Knowledge of authentication modes, types of roles, how to manage security accounts, grant revoke permissionto access data and how to make a security plan matching your business needs
• Implemented SQL Failover clustering for ACTIVE and Active Passive SQL Server 64 bit 32 bitsenvironment and SQL Server 2005 2008
• Implemented Database Mirroring on SQL Server 2008 environments and experience in configured andmaintained Log shipping on primary and secondary server with or without witness server on MS SQL 20052008.
• Implemented replication for database objects, Managed all Publisher, Distributor and Subscriber databaseenvironments for transactional, merge and snapshot replication
• Extensively used SQL PROFILER and QUERY TUNING Wizard to troubleshoot problems and queriesInvolved in tuning SQL Server databases using available tuning methods like index tuning wizards, profilerand execution plans.
• Created SSIS packages to Extract and Load data from diverse source (flat file, excel, xml and oracle) andalso Created Data Flows for Aggregate, sort, lookup, merge, union all and fuzzy lookups.
• Used Send Mail, Bulk Insert, Execute SQL, Data Flow, Import Export control extensively in SSIS
• Performed Multi File Imports, Package configuration, Debugging Tasks and Scripts in SSIS