SUMMARY

• Over 7 Years of Experience in Oracle Database and Application Servers
• Over 2 Years of Experience in Server Sizing and Requirement Gathering
• Implemented Production environments and backup databases for critical applications in Finance Vertical
• Implemented ASM architecture and configured Database for production environment for logistic application
• Conducted requirement analysis for production environment and streamlined backup policies for more than 20 databases using RMAN
• Gathered requirements to automate reports assessing database performance and made changes in the database environments for optimal performance
• Identified risks and issues with respect to the production release and discussed with client team to mitigate them
• Assessed Production environment and shared documentation for migration strategy
• Developed lab environments to replicate issues in Production setups
• Upgraded high volume databases for critical production environment in aviation industry
• Conducted Disaster Recovery Drill as part of Business Continuity plan for various Banking applications
• Monitored performance of database and automated health check reports to proactively resolve database performance issues
• Consolidated databases on Oracle Exadata and reduced infrastructure cost by 30%
• Proficient with SQL query and worked on projects to optimize database performance
• Worked on Proof of Concept projects for Oracle Application Server and Oracle Golden Gate
• Hands on experience on Hive Servers and Hadoop environment
• Mentored new associates in the team and conducted training sessions
• Build test beds for new associates in the team to build skillsets through hands on experience
• Ability to work on a fast - paced environment, Good team player and a good mentor to guide new team members
• History of award winning performance in environment building/implementation, problem solving, knowledge sharing within team members and customer satisfaction

TECHNICAL SKILLS

Oracle Database: 9i,10g, 11g R1,11g R2

Application Server: Oracle Application Server 10g

Operating System: Windows Server 2008, RHEL 5, RHEL 6, Solaris SPARC

Microsoft Databases: SQL Server 2005, SQL Server 2008

PROFESSIONAL EXPERIENCE

Confidential, Detroit, Michigan

Lead Oracle Database Administrator

Responsibilities:

• Lead a team of 5 Oracle DBA and reviewed daily operations and issues observed in Oracle Database environment
• Shared migration strategy with the team and mentored associates in resolving database issues and challenges
• Reviewed daily and weekly reports shared by offshore team on the lights on activity
• Worked with application team in resolving issues in query performance during Performance Acceptance Testing
• Identified and decommissioned databases not generating business values reducing infrastructure cost by 10%
• Reviewed architecture of current database environments and suggested possible backup policies to be implemented along with best practices to resolve performance issues
• Created user policy to assign appropriate system privileges and policies to database users
• Shared user policy documents and implementation strategy and conducted regular follow ups
• Conducted weekly standups with team members to assess possible issues being observed to the current projects being assigned
• Developed skillsets for Hadoop environments and build Hive Servers for Proof of Concepts
• Conducted knowledge transfer sessions for Hadoop environments as part of learning curve

Environment: s: Oracle 10g, Oracle 11g R1, Oracle 11g R2

Confidential, Naperville, Illinois

Sr. Oracle Database Administrator

Responsibilities:

• Build ASM storage environments on test bed and developed migration strategy to migrate databases from non-ASM to ASM environment using RMAN
• Build ASM Dataguard environment for 2 node RAC cluster and automated scripts to monitor dataguard synchronization of archives with Production Environment
• Build active dataguard environment and suggested application team to offload weekly reports on active dataguard environment
• Build test bed environments and shared migration strategy with all concerned stakeholders
• Streamlined backup policy for more than twenty database environments and automated scripts to monitor success of backups
• Performed database and sql tuning using EXPLAIN PLAN, AWR, TKPROF and hints
• Developed Golden Gate test bed environment to create extractors and replicators for real time data replication
• Mentored new associates in the team and conducted knowledge transfer sessions to improve their Oracle DBA skills

Environment: s- Oracle 9i, Oracle 10g, Oracle 11g R1, Oracle 11g R2, Oracle 12c, Oracle FailSafe Manager

Confidential

Oracle Database Administrator

Responsibilities:

• Build dataguard environment for production environments and automated scripts to monitor the status
• Migrated database from Oracle 9i and 10g environment to Oracle 11g using EXPDP and RMAN backups.
• Created test environment and assisted production team in assessing all possible risks associated with the production cutover
• Build test database environments on Linux and Solaris Environments
• Conducted reorganization of critical database schemas to improve performance of database
• Automated scripts to assess roles and privileges granted on production environment and shared the output with clients to adhere their compliance standards
• Revoked roles and privileges from test bed environment and assisted application team in validating the risks associated at Production Environment
• Highlighted index and tables which required index rebuild and table reorg and incorporated them in automated scripts
• Extracted AWR, ADDM report from Production environment and assessed reports to resolve resource contention and performance issues
• Performed 24/7 on call support during weekend with dedicated application team members including night time and monthly production outage
• Automated RMAN backup scripts and shared status reports with concerned stakeholders
• Conducted disaster recovery drills for clients using Production Database and Oracle Dataguard, Physical standby environment as part of business continuity exercise
• Developed and lead migration strategy to move MIS databases from traditional database environments to Oracle Exadata

Environment: Oracle 9i, Oracle 10g, Oracle 11g R1, Oracle 11g R2

Confidential

Junior Oracle Database Administrator

Responsibilities:

• Scheduled cold backup, export backup and RMAN backup for critical production environment
• Conducted lights on activity and shared report with seniors to assess performance of database
• Granted privileges and roles in compliance with the business requirements of clients
• Executed scripts to remove data from staging tables in test environment
• Created databases for test environment and migrated data from Production Environment to Test Database.
• Executed index rebuild and stats gather scripts to improve performance of database
• Received recognition from client for proactively resolving database issues
• Refreshed test database environments using EXPDP and RMAN backup and reviewed with application team to assess possible issues post refresh
• Installation of Oracle Binaries 11g R1 and 11g R2 on test beds and lab environments
• Deployed test databases in lab environments
• Replicated issues in test environment and shared root cause analysis report with clients

Environment: s- Oracle 9i, Oracle 10g, Oracle 11g R1, Oracle 11g R2