SUMMARY:

• Over 15 years of IT experience working in infrastructure management areas like Oracle, MSSQL database and Windows server administration.
• Proficient in managing and delivering projects involving Oracle and Microsoft SQL Database products. Managed and supported projects on various stages from planning, proposal, estimation and implementation.
• Well versed in understanding Business requirements, Recommending and adopting the latest technologies.
• Experience in Managing DBA teams & Large databases, installing, Implementing advanced Technologies like RAC, Data guard, migration and production support.

TECHNICAL SKILLS:

RDBMS: Oracle 11gR2,10g, 9i, 8i,MS SQL Server 2005,2008, 2012

Hardware and Operating Systems: Red hat enterprise Linux 6, Solaris 9, AIX 4.3, HP UX, Solaris,Windows

Oracle Engineered systems: ODA, Exadata

Methodologies: ITIL, Project Management, SDLC

Backup Software: Netbackup, AutoSys Scheduler, Control M,RMAN, Business Continuance Volume

Performance Monitoring & Licensing Tools: BMC Patrol, OEM 12C, SCOM, Nagios, Flexera

Database Performance Monitoring and Analysis Tools: OEM Grid Control, SQLT, Explain Plan, AWR, ASH, ADDM, OSWatcher,Health Checks - ORACHK, ODACHK, SQLhc, PXcdr, Streams hc, RDA

Spotlight Application Landscape: SAP ERP CENTRAL COMPONENT (ECC6),,Discoverer, DSNavigator, LIMS, Qualtrend,,Cognos, Informatica, TIBCO, MQ,,Pitney Bowes (Shipping), MAXIMO,Siebel Clinical Trial Management System,Siemens Camstar Medical Device Suite (MES)

PROFESSIONAL EXPERIENCE:

Confidential,Temecula,CA

Technical Project Lead/Senior Database Administrator

Responsibilities:

• Design, Build new database servers, Plan and implement Backup, Recovery strategy
• Annual Database User Recertification and Software License Management
• Database upgrade, migration plan and execution,Effort and Cost estimation for database projects
• Perform Oracle Instance and Query tuning to achieve acceptable performance
• Collaborate with Project Team, Vendor to deliver database tasks related to projects on time
• Managing database backups and restores in line with business defined Recovery Time objective RTO and Recovery Point Objective RPO
• Develop and implement Database Administration process and procedures in line with ITIL and industry best practices
• Plan and Perform database disaster recovery exercise
• Implement Data encryption using Transparent Data Encryption
• Represent Database Team in PPM, RCA and Change Advisory Board Meeting
• Co-ordinate with vendors and other teams for problem resolution
• Define, plan and implement database retirement process
• Perform Capacity Planning and Sizing of database server for various Co-ordination between onsite and offshore teams.
• Project Planning, coordinating resources, working with vendors, moderating project Meetings, authorizing Project Minutes, and tracking milestones/issues/risks
• Oracle database administration tasks including daily checks, configuration management, backup/recovery, performance optimization, and space management, Install Packages on Linux system for Oracle

Confidential,Temecula,CA

Technical Project Lead

Responsibilities:

• Design, Build new database servers, Plan and implement Backup, Recovery strategy
• Prepare detailed Database upgrade, migration plan and effort and Cost estimation for database project
• Perform Oracle Instance and Query tuning to achieve acceptable performance
• Collaborate with Project Team, Vendor to deliver database tasks related to projects on time
• Implement database backups and restores in line with business defined Recovery Time objective RTO and Recovery Point Objective RPO
• Co-ordinate with vendors and other teams for problem resolution
• Co-ordination between onsite and offshore teams.
• Project Planning, coordinating resources, working with vendors, moderating project Meetings, authorizing Project Minutes, and tracking milestones/issues/risks
• Perform Installation/ Operation Qualification

Confidential,Temecula,CA

Senior Database Administrator

Responsibilities:

• Design, Build new database servers, Plan and implement Backup, Recovery strategy
• Annual Database User Recertification and Software License Management
• Perform Oracle Instance and Query tuning to achieve acceptable performance
• Collaborate with Project Team, Vendor to deliver database tasks related to projects on time
• Managing database backups and restores
• Participate in database disaster recovery exercise
• Implement Data encryption using Transparent Data Encryption
• Represent Database Team in PPM, RCA and Change Advisory Board Meeting
• Co-ordinate with vendors and other teams for problem resolution
• Project Planning, coordinating resources, working with vendors, moderating project Meetings, authorizing Project Minutes, and tracking milestones/issues/risks
• Oracle database administration tasks including daily checks, configuration management, backup/recovery, performance optimization, and space management, Install Packages on Linux system for Oracle
• Perform Installation/ Operation Qualification

Confidential

Offshore DBA Team Lead

Responsibilities:

• Co-ordinate with the onsite database team and delegate task to the team and tracking
• Resolve problem and incidents assigned related to database
• Gather periodic database growth and user list for audit
• Monitor and responds to the database alerts
• Build new database servers, Perform Data refresh periodically on non-production environment
• Responsible for planning and applying database patch
• Create and maintain database maintenance job to cleanup trace files, dump file systems and backups
• Prepare AWR report and help application team in analyzing and fixing the performance problem
• Gather database statistics, Tracing and profiling the poorly performing SQLs
• Manage database backups and ensured that Disaster Recovery and Data Retention protocols adhered to corporate policies
• Responsible for performance tuning, Backup/recovery, Query Optimization, Security and disaster recovery
• Oracle database daily tasks including space report check, access management, high availability management using SRVCTL, CRSCTL, ASMCMD

Confidential

Offshore DBA

Responsibilities:

• Database problem and incidents management resolution
• Represent offshore team in daily and weekly status calls
• Build new database servers, perform Installation and Operational qualification documentation
• Support Change and Release implementation, perform Installation Verification.
• Managing Backups &Recovery, Security, Users, space Management
• Contribute to Project planning & Scheduling, Testing and implementing in production
• Responsible for Backup and Recovery strategy, Table, schema and database refresh

Confidential,Texas

Offshore DBA

Responsibilities:

• Participate in project transition at onsite and setting up database support team at offshore
• Lead the offshore team and perform daily database support requests
• Building new servers and upgrading the existing database to latest version
• Responsible for problem management and change management implementation
• Involved in instance tuning to maintain the server health
• Represent database changes in change approval board meeting
• Performing periodic tasks like Rebuild index, Statistics gathering, Log file backup
• Performance tuning using explain plan, SQL-Trace, STATS PACK reports
• Responsible for patching and performance tuning
• Schedule and maintain database maintenance jobs using Crontab, Windows Scheduler, Enterprise Manager
• Database refresh using export/import, RMAN, MS SQL Enterprise Manager
• Periodic cluster health check and tuning as required, Install and Maintain Oracle Real Application Cluster
• Monitored and optimized data storage for database systems and works with development teams on data sizing
• Resolved Windows platform issues related to SQL Server; and utilized SQL Server Integration Services
• Used stored procedures, DBCC and System Stored procedures, T-SQL, Triggers and other Database Objects
• Was responsible for performance tuning, Backup/recovery, Query Optimization, Security and disaster recovery
• Worked on multiple projects and platforms and converts Access databases to SQL Server databases

Confidential

IT Administrator

Responsibilities:

• Participate in project installation at onsite and setting up database systems
• Prepare a plan and upgrade Server, applications to latest versions
• Building new servers and upgrading the existing database to latest version
• Responsible for Client application installation and maintenance
• Windows, Application and Database server uptime
• Prepare plan and implement backup, recovery strategies
• Perform data refresh, Analyze index, statistics and rebuilding
• Applying application and database patches
• Resolve the problems and incidents raised
• Installing of software and database, Responsible for applying windows hotfix
• Responsible for user and password management