PROFESSIONAL SUMMARY

TOTAL IT EXPERIENCE: 10 YRS

• 10 Years of ORACLE / SQL SERVER DBA experience
• Experienced and result driven professional with strong organizational and interpersonal skills with proven track record of providing accurate and comprehensive software solutions seeking a challenging position as an ORACLE / SQL SERVER DBA in support of short-term and long-term projects related to Oracle database technologies.
• Language: English. Possess good communication skills oral, written and presentation .

TECHNICAL SKILLS

• SQL, PLSQL, T-SQL, SQL Loader, ODBC, JDBC, Oracle APEX formerly Oracle HTMLDB , JAVASCRIPT, XML, XSL, HTML, CSS, Cold Fusion, Shell Scripting, Batch Scripting, Visual Basic, J2EE
• PRODUCTIVITY TOOLS: Spot Light on Oracle and SQL Server, Redgate's SQL Backup Bro, SQLSentry, Idera, DB Artisan, Oracle Export/Import, Oracle Tuning and Diagnostic packs , SQL Loader, Litespeed
• Sunspace Servers, Sun Intel Systems, PCs, Compaq Servers, HP.
• Windows 2000 Advanced Server, 2000 Professional, NT/2000/2003/XP/VISTAS, OS/2/98/95, Solaris 6/7/8, 9, Red Linux, HP-UX 11
• Databases: Oracle 11G, 10G, 9i, 8i, MySQL, Postgres 8.1, MS SQL 2005, MS Access
• TCP/IP Protocols and Commands, OCFS2, ASM, TOAD, OEM, SQL Developer, Erwin, Visio
• Office 2000 suite of products, OASIS, Reveal, etc.

PRORFESSIONAL EXPERIENCE

Confidential

• All duties and responsibilities of a SQL Server DBA not limited to providing online support and configuration of include failover cluster, database mirroring, log shipping and replication to mention a few.
• Implementation of databases and data schemas Advanced Database tuning expertise Problem determination and resolution Assisting and guiding developers with any issues they may have...
• Responsible of administering and troubleshooting various Applications SAP BPC, BMC etc related issues.
• Administered and maintain the security and integrity of the databases.
• the SQL Server database, performance tuning, backup and recovery and all the high availability solution of the SQL Server which
• Created database objects and maintain their physical organization / relationships
• Managed the on-site backup and recovery process and / or support of the off-site backup and recovery teams
• Planed for and execute any required database upgrades and migration patches, etc.
• Communicate database requirements to the development team for the design and implementation of database-related code
• Performed overall health check as they pertain to performance tuning, backup and recovery, etc. heterogeneous environment.
• Assisted in developing departmental technical policies and procedures

Confidential

• Experienced in SQL SERVER 2005, 2008, 2008R2 and 2012
• Enhanced site monitoring to improve availability and performance
• Performed database capacity planning and trend analysis
• Database administration, installation, performance tuning, cloning and upgrade of Oracle 10g and 11g.
• Implementation and troubleshooting of Oracle RAC and Data guard databases.
• Implementation and troubleshooting of SQL server clusters and replication/mirroring features.
• Responsible for managing Oracle, Linux, Windows, SAN storage, and SQL server backups.
• Experienced in database administration including all phases of SDLC in installation, backup and recovery, tuning, migration, cloning, patching, upgrades and Importing/ Exporting data etc. as well as end user support.
• Responded appropriately to event tickets with expediency required to meet service level agreements.
• Achieved expert level of competence in one RDBMS discipline.
• Maintained a high level of knowledge in the capability of the monitor software Patrol/direct VIEW ...
• Engineered database administration tasks and participated in ongoing process improvement.
• Developed and implement database performance monitoring process and analyze monitoring data for performance optimization opportunities
• Managed the on-site backup and recovery process and / or support of the off-site backup and recovery teams .
• Experienced in support of SQL Server 2000, 2008, and 2012 standalone and High Availability systems such as standard SQL Server clustering and Availability Groups
• Experienced in advanced level T-SQL skills including triggers, stored procedure, views, etc.
• Knowledgeable in Database Backups, Change Data Capture, and Extended Events
• Accurate understanding preservation of data integrity e.g. referential integrity
• Accurate understanding of the requirements for differing types of applications e.g. OLTP vs. Reporting
• Knowledgeable in database disk utilization and performance tuning concepts and tools

Confidential

Oracle/SQL SERVER DBA

• Partnered with offshore DBA resources and thoroughly document processes to ensure successful implementation by offshore staff and Production Control
• Managed and ensured database objects views, stored procedures, triggers, constraints, etc. and SQL statements meet performance and security objectives
• Maintained the integrity of data within the production environment including the execution of proper backup and restoration policies and procedures which provide point-in-time restore capabilities
• Provided development and testing support to programmers and engineers to efficiently utilized databases.
• Determined security user access levels and application security models.
• Implementation of database schema level objects to support logical/physical model.

Confidential

Oracle/ SQL SERVER DBA

• Performed overall health check as they pertain to performance tuning, backup and recovery, etc. heterogeneous environment.
• Extensive experience in a production Oracle 9i/10gR2/11g environment including PL/SQL, OEM Grid control, Data Guard, ASM, RMAN, Partitioning, database tuning and troubleshooting.
• Planned, implemented and maintained Disaster Recovery methodology for all production databases
• Acted as Manager/Team Lead for other Database Administrators
• Worked with technical architects to ensure data model meets the platform s requirements for the business and technical perspective.
• Defined business object/database table mappings and structures, fail-over strategies and distributed data strategies.
• Ensured database objects views, stored procedures, triggers, constraints, etc. and SQL statements meet performance and security objectives
• Developed and implemented standards for data object naming and database design
• Produced technical documentation related to the databases under management according to technology standards
• Administered and maintained the security and integrity of the databases. Implemented data models and database designs, data access and table maintenance codes. Resolved database performance issues, database capacity issues, replication, and other distributed data issues. Led the efforts of installing and maintaining database management software.
• Worked with the Information / Data Architect and Database Designer / Modeler to help implement the physical data model for the development and / or production environments

Confidential

Oracle/SQL SERVER DBA

• Build high availability systems by using clustering, mirroring. Researched and resolved SQL Server Software and Database issues, established and maintained backup and recovery processes.
• Basic knowledge of BMC Patrol for SQL Server, expertise in SQL Litespeed.
• Expert knowledge of SQL database security.
• Experienced in monitoring and tuning of SQL Server 2005 2008 system
• Deployed and upgraded engines clients
• Analyzed Key Performance Metrics using OEM management packs
• Optimized Oracle resource utilization by tuning queries, recommending indexes, and configuring database instance parameters
• Provided input on the selection and implementation of all database administration tools
• Maintained the integrity of data within the production environment including the execution of proper backup and restoration policies and procedures which provide point-in-time restore capabilities
• Enhanced site monitoring to improve availability and performance
• Performed database capacity planning and trend analysis
• Database administration, installation, performance tuning, cloning and upgrade of Oracle 10g and 11g.
• Implementation and troubleshooting of Oracle RAC and Data guard databases.
• Implementation and troubleshooting of SQL server clusters and replication/mirroring features.
• Responsible for managing VERITAS Net Backup, Oracle and SQL server backups.
• Experienced in database administration including all phases of SDLC in installation, backup and recovery, tuning, migration, cloning, patching, upgrades and Importing/ Exporting data etc. as well as end user support.
• Proficient in Tuning the performance of the databases and troubleshooting the issues
• Strong hands on experience with tuning SQL, stored procedures, functions, packages.
• Determined security user access levels and application security models.
• Provided development and testing support to programmers and engineers to efficiently utilized databases.
• Troubleshot database and application performance, tuning of Oracle Instances and application SQL
• Implementation of database schema level objects to support logical/physical model.
• Strong working knowledge of Oracle DBA best practices e.g., schema management, index optimization, and use of hints .

Confidential

Oracle/SQL SERVER DBA

• Experienced with HP-UX in securing critical applications are always-on and without any compromise.
• Ensured database migration scripts and programs meet data integrity, performance and security objectives.
• Maintained and published the database installation/operation guide and other pertinent documentations
• Responsible for ensuring the availability and performance of the production and development database environments
• Responded appropriately to event tickets with expediency required to meet service level agreements.
• Achieved expert level of competence in one RDBMS discipline.
• Maintained a high level of knowledge in the capability of the monitor software Patrol/direct VIEW ...
• Engineered database administration tasks and participate in ongoing process improvement.
• Created ad-hoc customer reports as requested where indicated, engineered ongoing automation.
• Took requested out-of-scope tasks to CRM for handling.
• Provided support to CRM teams for customer service reviews.
• Managed/direct large scale RDBMS projects including but not limited to upgrades and migrations.
• Provided direct support and mentoring to more junior team members
• Demonstrated customer care in handling of all communications.
• Showed flexibility in handling variety of support requests.
• Provided the architectural designs for new solutions, growth, redundancy, and performance and availability enhancements.
• Developed and implemented standards for data object naming and database design

Confidential

Oracle/SQL SERVER DBA

• Provided front-line database support supporting client facing applications
• Researched, design and implement new technology and database features
• Backup/recover strategy and planning
• Participated in disaster recovery planning and execution
• Responsible for problem escalation to Oracle Support and third parties as necessary
• Worked closely with customers and internal staff on database design and construction of customer databases
• Researched and recommended technology selections
• Worked as part of a project team to coordinate database development and determine project scope and limitations.
• Acted as a database subject matter expert supporting our product engineering and support teams
• Provided experienced technical consulting in the definition, design, and creation of a data base environment
• Advised applications development staff and users on data base solutions to business problems, data architectures, data base management system facilities and capabilities, and the operation and tuning of data bases
• Ensured economic and efficient availability of data within adequate safeguards
• Designed and implemented databases with respect to access methods, access time, batch processes, device allocation, validation checks, organization, protection and security, documentation, and statistical methods
• Developed and maintained expertise in use of automated tools for database design and implementation
• Developed, maintained and documented, shell scripts and batch processes. Served as a team player, and worked to maintain a positive environment

Confidential

Oracle/SQL SERVER DBA

• Assisted with application upgrades, migrating objects from development to test and test to production representing changes as necessary in Change Management
• Participated in Disaster Recovery planning and testing
• Participated in On Call rotation for off hours enterprise database support
• Created database objects and maintained their physical organization / relationships
• Developed and implement database performance monitoring process and analyze monitoring data for performance optimization opportunities
• Managed the on-site backup and recovery process and / or support of the off-site backup and recovery teams
• Planned for and execute any required database upgrades and migration patches, etc.
• Communicated database requirements to the development team for the design and implementation of database-related code
• Developed and implemented standards for data object naming and database design
• Produced technical documentation related to the databases under management according to technology standards
• Installed, configured, upgraded, migrated and patched Oracle 9i/10gR2/11g databases
• Strong technical understanding of Oracle database 9i/10g internals, including RAC, Streams, Data Guard,
• Broad knowledge in various database backup and recovery methodology's, software and technologies.
• Used Fog light monitoring tools and its integration with Oracle databases.
• Installed and configured Oracle 10g and 11g instances in both dedicated and consolidated environments
• Applied regular maintenance and critical patch updates in a timely manner Proactively researched potential issues that may be encountered as a result of infrastructure upgrades and shared that information with the affected groups
• Experienced with Erwin in the modeling, design, support and physical implementation of database.
• Used Oracle and 3rd party tools to troubleshoot and resolve production issues
• Led, mentored and/or provided guidance to less experienced database analysts where applicable including guidance for troubleshooting escalated issues
• Partnered with offshore DBA resources and thoroughly document processes to ensure successful implementation by offshore staff and Production Control
• Provided trend analysis to management team to enable them to make informed decisions regarding resource management