SUMMARY:

18, years of experience in Database Administration and Developer for very large and complex databases in Oracle 9 To 12C, SQL Server 2012, SQL Server 2014, SQL Server 2008 R2, 2008 and 2005.An experienced IT professional with databases & Unix, windows, administration skills across both Oracle, SQL Server and Postgresql.

TECHNOLOGY SUMMARY:

Systems: CICS/ISPF/Mainframe, Unix, Windows 9X/NT/2000/XP/2K3, Novell NetWare, Mac OS, Korn Shel

Databases: Oracle version 9 to 12C, Grid Control, OEM, RMAN / AWR /ADDM/ASH, RMAN, DBMS SQLTUNE, Dataguard.

Postgresql: 9.2, 9. 5, 9.6, PgAdmin4, Pg bacrest, PG Bouncer

Sql Server: 2000, 2005, 2008, 2014 Transac Sql

Languages: Visual Basic, SQL, HTML, ASP, CSS, C++, CGI, Perl, Java

Software: MS Project, MS Visio, MS Office, Lotus Notes, Toad

IT EXPERIENCE:

Confidential

Oracle DBA

Responsibilities:

• Responsible for the technical and administration aspects of the companies Oracle and Postgresql Database infrastructure
• Able to effectively communicate technical data to non technical colleagues. .
• Experience with RAC, ASM, instance tuning and SQL tuning..
• Diagnostic, Tuning, Configuration and Change Management Packs.
• Installation, patching, upgrading, configuration, management and trouble - shooting databases.
• Manage database objects, perform configuration, patch, performance tuning, manage capacity, free space, and logs.
• Configuration Higth disponibility on Postgresql
• Replication database Postgres, Backup and restauration,
• Clustering Postgresql (Master/slave)
• Migration Mysql 5.5 to Postgresql 9.8
• Tuning, Performance, and Upgarde Postgresql version

SQL Server DBA

Confidential

Responsibilities:

• Strong ability to work independently and manage one's time.
• Good knowledge of High Availability (HA), Always On and Disaster Recovery (DR) options for MSSQL Server
• Ability to apply detailed knowledge of organizational procedures to make independent decisions and serve as a credible resource for a senior management team
• SQL Server 2005/2008 / 2008 R2 / 2012 & 2014 optimization, fine-tuning, and scalability techniques with knowledge of SSIS
• Strong knowledge of MS Office products
• Highly proficient in SQL, stored procedure and CLR in SQL Server

Confidential

Oracle DBA

Responsibilities:

• I was a member of the Production DBA team who supported a variety of business systems ranging from Oracle 8.1 to 12R2, running on AIX.
• Joint Technical Lead on Oracle Grid Control and Audit Vault implementation project.
• Refined a full production copy test environment refresh procedure for Investments projects, reducing the duration dramatically and improving reliability.
• Worked closely with Group Information Security on development of group-wide database security standards.
• Helped implement a pair of 10.2 RAC/ASM/Grid Control clusters on Linux for performance testing.
• Support the analytics and business operations teams in executing data requests and analyses (e.g. creation of temporary tables, performance tuning)
• Support the system operations team in managing production.
• Backup and restoration
• Migration Mysql To Postgresql
• Developing and maintaining O&S operating procedures for the Compute infrastructure in addition to providing on-the-job training to AIT O&S Tier II personnel, Perform SQL administrative tasks including installing and upgrading SQL server products, creating maintenance plans, and creating database objects, Install, configure and deploy MS SQL Server. Perform capacity planning, performance turning, monitoring, troubleshooting and optimization of the databases
• Prepares users by conducting training; providing information; resolving problemsDesigning and running system load/stress testing; escalating application problems to vendorsStandardize and manage Database Administrator procedures for monitoring database performance, testing, archiving, and optimizing, Maintenance and support of SQL server Mirroring, Log shipping, Clustering, and other methods of disaster recovery

Confidential

Oracle DBA

Responsibilities:

• MCO application and Commissioning Production of new Siebel, Sap
• Administration Oracle Database 10g in Siebel applications and Sap
• Incident Management on Production bases
• Performance tuning, tuning applications and Oracle databases
• Installation and Administration Dataguard
• Writing documentation for the implementation of Dataguard
• Installing and Administering MySQL databases 5.1.2
• Support Level 2 and 3

Confidential

Oracle DBA

Responsibilities:

• Perform all configuration and maintenance-level database administrative functions.
• Analyze and resolve database user ticket issues.
• Manage database user account creation, access and permissions.
• Perform operations in a manner in which the impact on database downtime is minimized and in accordance with established customer standard operating procedures.
• SQL tuning, backup and restore.
• Performance tuning, tuning applications and Oracle databases
• Oracle database migration to 10G 11R2 oracle
• Incident Management on Production base
• MCO application
• Establishment Dataguard on 11R2
• Recovery Plan Activity

Confidential

Oracle DBA

Responsibilities:

• Helped implement a pair of 10.2 RAC/ASM/Grid Control clusters on Linux for performance testing, monitoring scripts for a new client, making modifications necessary for them to work in a RAC environment
• Implemented standard.
• Tuned a number of significant batch jobs, reducing execution times from hours to minutes.
• Significant server consolidation activity in co-operation with the Unix Sys Admin team
• Provide architectural solutions covering data structures, integration, security, and retention.

Confidential

Oracle DBA

Responsibilities:

• Created new database for the customer and export other monitoring scripts.
• Implemented database refresh using full export for table level and full database Defragmentation, resulting improved performance and effective space management.
• Generated reports from the database using PL/SQL and SQL.
• Added more new features to existing analysis software tools.
• Trained a new DBA in our environment.
• Work beyond regular hours based on business demands. Provided 24x7 on-call

Confidential

Oracle DBA

Responsibilities:

• Establishing the logical standby database,
• Technical support to development teams,
• PSI (computer backup plan), PRA (disaster recovery plan Manage privileges on environments,
• Tuning databases,
• Management of different environments: development, integration, qualification and production Oracle Level 3 support for production platforms,
• Operational maintenance of applications in production,
• Database Migration Oracle 8i to Oracle 9i,
• Database migration to Oracle 9i 10G.
• Set up backup procedure and restore using RMAN

Confidential

Oracle DBA

Responsibilities:

• Partitioning tables large volume and maintenance,
• Creating the indexing plan
• Tuning databases,
• Management of different environments: development, integration, qualification and production
• Consolidation of the storage system for performance optimization,
• Operational maintenance of applications in production,
• Database Migration Oracle 8i to Oracle 9i,
• Creation of logical and physical standby database,
• Backup and restore using Rman.
• Performance tuning, not performance monitoring

Confidential

Oracle DBA

Responsibilities:

• Installation Oracle 9i
• Creating databases in Oracle 9i,
• Clusterisations instances in 9iRAC two nodes with Oracle Fail Safe,
• Configuring RMAN backup and production bases with RMAN,
• Tuning, performance, backup, and restore Oracle databases (RMAN)
• Statistics calculation with Stat pack,
• Audit and consulting on strategies of governments and backups,
• Maintenance and operation of applications,
• Support to development teams,
• Optimizing Queries (introduction of HINTS).

Confidential

Oracle DBA

Responsibilities:

• Installed and configured Oracle Database on Red Hat Linux Advance Server on Development.
• Involved in performance monitoring and tuning of the database.
• Involved in backup and recovery tasks using RMAN.

Confidential

Oracle DBA

Responsibilities:

• Experience of using SQL, both as a scripting language and from within Java, using the JDBC interface. Other databases rarely used are Access, Oracle and PostgreSQL.
• Support to clients Programming logic and Technique (data type and identification, decision flowcharts, operators)
• Implementing Database design using Oracle 9i (Query, Retrieve DB, Functions And
• Creating databases,
• Administration 400 Oracle databases,
• Tuning and performance of databases (regular measurement of performance parameters, Hit Ratio, Share pool etc ...)

Confidential

Oracle DBA

Responsibilities:

• Oracle kernel Installation V9i,
• Modeling and Design of documentary databases,
• Creating Oracle databases,
• Functional analysis, modeling, implementation and tuning of Oracle database,
• Analysis of the functional and technical integrity of the data supplied.
• Optimizing supply processes, backup and restore via the study of queries execution plans (Explain Plan).