SUMMARY:

• Oracle 10g,11g, and 12c database administration on Linux and Windows platforms
• MSSQL Server 2008, 2012 database administration on Windows Server
• Database Duplication, Migration, Refresh, Upgrade and Patch application
• Database design using TOAD and ERWIN
• Physical (RMAN) and Logical (Expdp/Impdp) database backup, restore, and recovery
• Performance turning (Proactive and Reactive maintenance)
• Administering and Managing RAC, ASM, RAID, Data Guard, and Golden Gate
• Administering cloud computing
• PL/SQL deployment
• Shell Scripting
• Capacity planning, sizing applications and server hardware
• User and security management
• Assisting developers with application design
• Collaborating with vendors, end users, and other support groups

TECHNICAL SKILLS:

Languages: SQL, T - SQL, PL/SQL, Java, C++

Databases: Oracle (10g,11g,12C), MySQL (5.5,5.6), SQL Server (2008,20012)

Operating System: Red Hat Linux OS, UNIX ( AIX, Solaris), Windows (2007, server, Vista, 2008, 2010)

Oracle Concepts: RAC, Data Guard, ASM, Oracle Enterprise Manager-Grid Control, Partitions, Oracle Transparent Data Encryption, Virtual Private Database, Golden Gate, Auditing (Fine grained auditing), Performance Tuning (AWR, ADDM, TOAD, OPTIMIZER), Oracle Jobs, RMAN, VMWare, Flashback, Oracle recycle bin, Oracle Advanced Queuing, Oracle Streams, Data Pump, SQL LOADER

PROFESSIONAL EXPERIENCE:

Confidential

Oracle & MSSQL DBA

Responsibilities:

• First hand monitoring of production database through 12c cloud control
• Utilized ASM to manage storage structures and space thereby completely eliminating space errors
• Configure databases for recoverability
• Manage Oracle 11g and 12c 2 nodes RAC database
• Manage RAC database using CRSCTL, SRVCTL, and grid control
• Manage RAC database on ASM storage
• Apply critical patch updates on RAC database using OPatch auto
• Configure and manage Oracle 11gR2 data guard
• Manage Data guard using data guard broker
• Troubleshoot and resolve log gap in data guard configuration
• Manage Oracle golden gate replication for high availability (HA)
• Validate RMAN Backup, restore and recovery of database physical files
• Administer cloud storage on Rackspace
• Configure Transparent Data Encryption for database security
• Perform Database refresh using Export and Import Data Pump
• Create database links to enhance developers
• Configured Transparent Data Encryption
• Utilized golden gate to sync data on heterogeneous platforms
• Manage and champion the migration of over 15T of data from 11gR2 to 12C (VLDB)
• Performance tuning of databases with optimizer, AWR, ADDM, explain plan and advisory frameworks
• Tune a lot of slow running queries and materialized views
• Provided proactive and reactive support to Coldfusion teams
• Performed operation and maintenance tasks at O.S and database level
• Monitor Sessions and resolve lock issues
• Created Shell Scripts to run background jobs in crontab.
• Perform bulk inserts using SQL loader tool
• Develop and manage PL/SQL stored procedures, triggers and packages
• Collaborate with developers to investigate database issues and execute scripts
• Document database structure, changes, problems, issues for future reference using one note

MSSQL SERVER 2008/2012

• Routinely monitored Server activity, error log and space
• Scheduled backup using Full, Differential and Transactional log backup process
• Installed and applied Service Packs updates
• Developed and managed security scheme for the database environment
• Create front end dashboards using SSRS, SSIS, and Tableau
• Created and ran jobs to rebuild and reorganize indexes
• Configured database mail and SQL server agent.
• Implemented the import and export of SQL server data on heterogeneous platforms
• Managed data replication of Oracle golden gate on SQL Server database

Oracle & SQL Server DBA

Responsibilities:

• First hand monitoring of production database through OEM Grid Control
• Managed storage structures and space thereby completely eliminating space errors
• Configured databases for recoverability
• Installed, configured and managed Oracle 11gR2 4 nodes RAC database
• Applied critical patch updates on RAC database in rolling manner
• Removed and added nodes on 11g cluster
• Configure and manage Oracle 11gR2 data guard
• Performed RMAN Backup, restore and recovery of database physical files
• Performed Data Pump Import and Export of database logical files
• Implemented flashback techniques (RMAN flashback, flashback drop, flashback database, flashback table)
• Created recovery catalog and register all our databases on it
• Operating System and database level performance tuning
• Tuned a lot of slow running queries and materialized views
• Created users, manage roles, and control privileges
• Assigned quotas on tablespaces for users
• Implemented periodic password changes on database users for application security
• Managed oracle connections and troubleshoot series of connectivity problems
• Control resource usage by users through auditing (Fine grained auditing)
• Duplicated production database for test purposes
• Did database migration and upgrade
• Prepared databases for quarterly patch updates
• Monitored Sessions and resolve lock issues
• Coded and ran jobs using shell scripting
• Performed bulk inserts using SQL loader tool
• Created SOP’s for database maintenance
• Documented database structure, changes, problems, issues for future reference using one note

Database Administrator / Analyst

Responsibilities:

• Performed database backup, recovery and restore
• Performed performance tuning on databases (Proactive and Reactive)
• Did SQL Profiling and audited the database
• Monitored production and test database usage and reported on database performance and system availability
• Monitored the appropriate distribution of free space within tablespaces
• Resolved locking issues and long transactions through SQL tunings
• Made use of SQL advisor to identify indexing and partitions using OEM
• Created entity relationship diagrams (ERDs) to design databases
• Analyzed table designs for excessive redundancy
• Created relational databases, and wrote SQL statements to extract information to satisfy reporting requests
• Utilized Tableau for business forecast
• Created and modified Tables /Views/Triggers/Stored procedures /Constraints/Indexes
• Managed external tables and directory objects
• Wrote triggers and stored procedures using PL/SQL
• Worked with COTS application
• Scheduled and maintained Oracle jobs using scheduler and DBMS JOBS
• Created lots of views, indexes and materialized views
• Installed oracle database on Linux and Windows platforms