SUMMARY

• Senior Oracle Database Administrator with 20+ years of experience and expertise specializing in areas of Oracle Database Administration and Development within single node and clustered infrastructure using Unix & Linux environments with system administration skills
• 20+ years of strong DBA skills and relevant experience in IT focusing on Oracle DBMS 11g, and 12c/18c
• Experienced in Oracle database administration within Unix & Linux environments with system administration skills including installing, configuring, migrating, and upgrading Oracle RDBMS
• Installed, configured, maintained, upgraded Oracle Databases, Multi node RAC, ASM & Active Data Guard
• Experience in implementing Highly Available features of Oracle databases and UNIX/Linux clustering
• Experienced in supporting developers. Developed and implemented data models, database schemas, various table types, triggers, indexes, sequences, constraints, functions, procedures and packages
• Designed data models, database review, modified existing codes and created new, tested upgrades as per establish standard and taking responsibility of main data resource in upgrades
• Experienced in troubleshooting technical issues using proven techniques and support processes
• Provided DBA support to databases in development, test and production environments
• Possess excellent interpersonal and communication skills. Able to work with and support colleagues
• Supported major application upgrade with strong analytical, working in a team as well as independent environment with minimal supervision and under pressure
• Experienced in coordinating with management team, providing work estimates, prioritize, manage and handle multiple tasks at one time
• Experienced in security concepts relevant RDBMS access control, backup and replication etc.
• Expert knowledge of database design, indexing, tuning, capacity planning, database best practices
• Development of SQL & SHELL scripting, PL/SQL packages, stored procedures, triggers
• Designed and implemented Oracle database backup and recovery strategy and tested regularly
• Experienced in Oracle Tuning/Diagnostics, monitoring, analyzing performance of queries & Databases
• Experienced in projects reviewing database structures, standards and procedures for databases
• Participated in exercises to improve quality/performance of teh large database applications
• Experience in supporting mission - critical production environment to ensure 24/7 availability
• Following ITIL standard incident handling, change management using SNOW, Jira, Confluence etc
• Oracle Certification in DBA ver. 8/8i/10g, 12c, Oracle RAC & Sun Solaris (Unix) System Administration

TECHNICAL SKILLS

Platforms: UNIX (Sun/Intel-Solaris), Linux (RHEL. Oracle, CentOS), Windows Server

Databases: Oracle, MS SQL Server, MySQL and Postgre databases

Languages: SQL, PL/SQL, SSH, Shell scripting, JAVA, JSON, XML, D/HTML, UML, CSS, XSD

Networking: LAN/WAN/VLAN/VPN, TCP/IP/HTTPS protocols

Data Models & Case Tools: ERD, DBMS, ERWIN, Oracle Designer

IDEs: Oracle SQL Developer, TOAD, Oracle JDeveloper, Eclipse, Microsoft SSMS, MySQL Studio

Cloud Services: Azure, AWS and Oracle Cloud

Business Intelligence/Reporting: Oracle BI, Oracle reports, Materials views, External tables, PL/SQL text

ETL/Datawarehousing: Oracle data integration (ODI), Talend

Tools: and Utilities PUTTY, Jenkins, Jira, Confluence, Bamboo

Version control system: GIT, CVS

Enterprise Content Management: Oracle Content Server, IBM FileNet, Sharepoint

PROFESSIONAL EXPERIENCE

Confidential

Database Administrator

Environment: Linux, Unix, Windows server, Azure, Shell script, Oracle Database 11G, 12C, RACL, MSSQL, MySQL, SQL, PL/SQL, DevOps, Docker, Service Now, Jira, Confluence

Responsibilities:

• Created database architectures, reorganization procedures, database alert scripts, monitoring migrating databases between software versions, platforms, and Database products
• Liaising with Project managers, End of Life, Delivery, Solution Architect and development teams to implement a solution dat meets business requirements within time and cost constraints
• Supporting developers by defining and maintaining multiple Oracle environments, creating database reorganization procedures for application development and testing
• Providing operation support, participating in teh replication, migration, deployment and management efforts
• Analyzing external vendor’s requirements for needed hardware/software resources and collaborate with operation support team, solutions Integration Architects, project managers and other team members to plan
• System Administration on Linux servers containing single and multi-node database
• Installing, configuration, maintaining DR solutions and creating Oracle maintenance plan, patching databases
• Monitoring database error logs, snapshots, indexes, tablespaces, fragmentation, transaction logs, etc,
• Daily health monitoring, Oracle reporting to ensure proper performance, capacity, availability, and recoverability
• Designing, developing and implementing database reorganizations, backup and recovery solutions
• Configuration management of Memory, CPU, Storage. Monitoring teh performance and tuning
• Adhere to and introducing corporate technical standards, processes and following best practices
• Providing recommendations on architectural standards and development activities
• Participating in teh researching and evaluating new database products and features
• Performing system automation using shell scripting and configuration management tasks
• Providing operation support and participating in teh architectural deployment and management
• Administration of existing databases and creation of new databases within Linux & Unix
• Helping infrastructure staff with providing needful to ensure high availability and optimal performance
• Security administration - Defining and implementing access controls and monitor user access to database
• Worked with external suppliers and service providers as needed
• Creating and updating Oracle build documentation, Oracle escalation processes and documentation
• Writing complex scripts for data manipulation, management, performing ETL
• Reviewing SQL and PL/SQL scripting by developers and propose improvements
• SQL optimization, Partitioning, Oracle Tuning and Diagnostics, triggers, procedures, packages, functions
• Managing Oracle operations for all Client-Bases Application in all environments
• Oracle Grid Control, ADDM, AWR and ASH analysis for performance improvements and Root Cause Analysis
• Optimizing SQL query plan stability by analyzing query path and parallel execution

Confidential

ORACLE DATABASE ADMINISTRATOR

Environment: Linux, Unix, Windows server, Shell scripting, Oracle Database 11G, 12C, Oracle RAC, MSSQL, MySQL, SQL, PL/SQL, XML, Pulse, Service Now, Jira, Confluence

Responsibilities:

• Providing Oracle Database Administration operational and development Level 3 support
• Supporting developers by defining and maintaining multiple Oracle environments, creating database reorganization procedures for application development and testing
• Enhance and support SQL databases with a focus on SQL and PL/SQL development
• Providing application developers by Oracle DBA liaison functions, assisting, implementing Oracle database
• Analyzing external vendor’s requirements for needed hardware/software resources and collaborate with operation support team, solutions Integration Architects, project managers and other team members to plan
• System Administration on Linux servers containing single and multi-node database
• Installing, configuration, maintaining DR solutions and creating Oracle maintenance plan, patching databases
• Monitoring database error logs, snapshots, indexes, tablespaces, fragmentation, transaction logs, etc,
• Daily health monitoring, Oracle reporting to ensure proper performance, capacity, availability, and recoverability
• Designing, developing and implementing database reorganizations, backup and recovery solutions
• Configuration management of Memory, CPU, Storage. Monitoring teh performance and tuning
• Working with a DBA team for Oracle problem identification, resolve any defects and caring pager for off-shift
• Created database reorganization procedures, database alert scripts, monitoring migrating databases between software versions, platforms, and Database products
• Adhere to and introducing corporate technical standards, processes and following best practices
• Providing recommendations on architectural standards and development activities
• Participating in teh researching and evaluating new database products and features
• Performing system automation and configuration management tasks
• Providing operation support and participating in teh architectural deployment and management
• Administration of existing databases and creation of new databases within Linux/Unix/Windows
• Helping infrastructure staff with providing needful to ensure high availability and optimal performance
• Security/Security administration - Defining and/or implementing access controls to teh data
• Worked with external suppliers and service providers as needed
• Worked towards integration, automation and continuous improvement
• Taking Pride in work with a keen interest in quality and learning

Confidential

DATABASE ADMINISTRATOR

Environment: Linux, Unix, Windows server, AWS, Azure, Shell script, Oracle Database 11G, 12C, MSSQL, MySQL, SQL, PL/SQL, DevOps, Docker, Service Now, Jira, Confluence

Responsibilities:

• Installation, configuration and management of database servers
• Participated in exercises to improve performance of teh application
• Ensured dat all problems and changes are addressed in a timely manner
• Installed, configured, maintained, upgraded Databases on Linux/Unix/Windows
• Ensuring security and business continuity through High availability, replication, standby database
• SQL scripting, PL/SQL scripting, SQL optimization, Partitioning, Oracle Tuning and Diagnostics, triggers, procedures, packages, functions
• Performance tuning, size, error logs, snapshots, indexes, tablespaces, transaction logs backed up, recovered, analyzed, defragged etc.
• Optimized SQL query plan stability by analyzing query path and parallel execution
• Designed database table using Clusters, Partition, Nested, IOT, Temporary and External Tables
• Implementing changes to developer, test and production database environments
• Demonstrated ability to work with enterprise-class client
• Leading team, coordinating with colleagues, working with internal and external
• Ability to organize, multi-task, establish priorities, manage one’s time and meet tight deadlines
• Security/Security administration - Defining and/or implementing access controls to teh data
• Performance - Ensuring maximum performance - Data modeling and optimization
• Monitoring database error logs, snapshots, indexes, tablespaces, fragmentation, transaction logs, etc,
• Determining required development tasks and provide general time estimates for these tasks, which are required by team leader or manager to fully schedule software projects.
• Performance tuning and query development, troubleshoot technical issues using proven techniques
• Support major application upgrade/restructuring, Work with other team members to resolve defects
• Participate in teh review of supporting documentation (user manuals, online halp, etc.)
• Participate in teh research of new technology to provide product innovation or problem resolution.

Confidential

DATABASE ADMINISTRATOR

Environment: Linux, Unix, Windows server, Shell script, Oracle RAC, Oracle Database 10G, 11G, 12C, ETL, Oracle Data Integration (ODI), Talend, OBIEE, SQL, PL/SQL, ERWIN, Oracle partitioning, XML, JSON, HTML, Jira, Confluence

Responsibilities:

• Created database architectures, reorganization procedures, database alert scripts, monitoring migrating databases between software versions, platforms, and Database products
• Liaising with Project managers, End of Life, Delivery, Solution Architect and development teams to implement a solution dat meets business requirements within time and cost constraints
• Defining data migration strategy for large data and performing data migrations
• Development of SQL & SHELL scripting, PL/SQL packages, stored procedures, triggers
• Supporting developers by defining and maintaining multiple Oracle environments, creating database reorganization procedures for application development and testing
• Performing pro-active monitoring of storage and providing capacity planning
• Providing operation support, participating in teh replication, migration, deployment and management efforts
• Analyzing external vendor’s requirements for needed hardware/software resources and collaborate with operation support team, solutions Integration Architects, project managers and other team members to plan
• System Administration on Linux servers containing single and multi-node database
• Installing, configuration, maintaining DR solutions and creating Oracle maintenance plan, patching databases
• Monitoring database error logs, snapshots, indexes, tablespaces, fragmentation, transaction logs, etc,
• Daily health monitoring, Oracle reporting to ensure proper performance, capacity, availability, and recoverability
• Designing, developing and implementing database reorganizations, backup and recovery solutions
• Configuration management of Memory, CPU, Storage. Monitoring teh performance and tuning
• Adhere to and introducing corporate technical standards, processes and following best practices
• Providing recommendations on architectural standards and development activities
• Participating in teh researching and evaluating new database products and features
• Performing system automation using shell scripting and configuration management tasks
• Providing operation support and participating in teh architectural deployment and management
• Administration of existing databases and creation of new databases within Linux & Unix
• Helping infrastructure staff with providing needful to ensure high availability and optimal performance
• Security administration - Defining and implementing access controls and monitor user access to database
• Developing and following established security compliance, audit and access management/control policies
• Worked with external suppliers and service providers as needed
• Creating and updating Oracle build documentation, Oracle escalation processes and documentation
• Writing complex scripts for data manipulation, management, performing ETL
• Reviewing SQL and PL/SQL scripting by developers and propose improvements
• SQL optimization, Partitioning, Oracle Tuning and Diagnostics, triggers, procedures, packages, functions
• Managing Oracle operations for all Client-Bases Application in all environments
• Performing ongoing maintenance, support and performance tuning of teh backend & application tunning
• Oracle Grid Control, ADDM, AWR and ASH analysis for performance improvements and Root Cause Analysis
• Optimizing SQL query plan stability by analyzing query path and parallel execution
• Source control and approving database changes using CVS, GIT and Gerrit etc

Confidential

DATABASE DEVELOPER and ADMINISTRATOR

Environment: Linux/Unix/Windows server, Oracle Database 10G, 11G, Oracle Forms, Oracle Reports, Data Warehousing, ETL, SQL, PL/SQL, XML, JSON, SOAP, REST, HTML

Responsibilities:

• Setting up and management of Oracle RAC in production environment
• Installed and configured active Data Guard and testing failover / switchover
• Designed and implemented backup and recovery strategy and tested regularly with Operations
• Development of PL/SQL packages libraries and DDL, DML and ETL scripts
• Configuration and managing of TED and Oracle backup & recovery, and Oracle Enterprise Manager
• Development of SQL, PL/SQL stored procedures, triggers and indexes
• Setting priority with team leader, delivering work on schedule and meeting deadlines
• Designed, tested, implemented, tuned, monitored, performance tuning database solutions
• Adhere to corporate technical standards, processes and best practices
• Providing recommendations on architectural standards and development activities
• Being a main player for database support during teh application upgrades
• Worked closely with external teams during System Development Life Cycle
• Supported developers, created database reorganization procedures, database alert scripts, monitoring migrating databases between software versions, platforms, and Database products
• Provided extensive technical and operation support development and production database systems