We provide IT Staff Augmentation Services!

Database Administrator Resume

2.00/5 (Submit Your Rating)

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 the 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 that 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 the 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 the 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 the researching and evaluating new database products and features
  • Performing system automation using shell scripting and configuration management tasks
  • Providing operation support and participating in the 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 the 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 the researching and evaluating new database products and features
  • Performing system automation and configuration management tasks
  • Providing operation support and participating in the 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 the 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 the application
  • Ensured that 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 the 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 the review of supporting documentation (user manuals, online halp, etc.)
  • Participate in the 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 that 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 the 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 the 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 the researching and evaluating new database products and features
  • Performing system automation using shell scripting and configuration management tasks
  • Providing operation support and participating in the 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 the 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 the 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

We'd love your feedback!