Dba Resume Examples

dba

  • Oracle 8i and 9i managment and standby db implementation.
  • MySQL management and binlog replication setup.
  • DB2 management.
  • Postgres management.

dba

  • Installation and configuration of MSSQL Server and CentOS.
  • Installation of SSMS in MSSQL Server and MySQL and Percona in CentOS.
  • Linux and Windows Command.
  • Replication through Percona in MySQL.
  • Replication and mirroring in MSSQL.
  • Develop or maintain archived procedures, triggers, or queries for applications.
  • SQL DDL, DML, DCL and TCL Commands.

sr. dba

  • Monitoring the Prod, Pre-prod, Dev and Test database.
  • Converting Primary to standby and Standby to Primary on half yearly basis.
  • Experience in monitoring the tablespace and add/resize the datafiles if reaches threshold.
  • Monitoring the RMAN online and incremental backups and resolving the backup failures.
  •  Interacting the oracle support for the different error like ORA-600, ORA-7445, ORA-1092 etc.
  • Experience in oracle 10g installation using Graphical and Silent method.
  • Creating users and assigning the privileges, profiles, roles to users as per client request.

sr. dba

  • Converting Primary to standby and Standby to Snapshot DB
  • Interacting the oracle support for the different error like ORA-600, ORA-7445, ORA-1092 etc.
  • Experience in Database point in time recovery for restore the missed objects
  • Linked Servers to MySQL and Oracle in MSSQL.

dba

  • Application and server logs using SSHClient and MobaXterm.
  • SQL Server Agent for Job Schedules and track job processing via agent.
  • Hands on experience on OLTP and OLAP System along with ETL Process.
  • Experience in patching activities in both RAC and standalone Environment.

dba

  • Managed databases in Acces 99 and SQL Server, making backups, data migrations and optimizing general data objects.
  • Generated new database objects like SP’s, views, jobs, triggers and tables according to user requests from different internal departments.
  • Generated reporting queries for specific time periods, offering analysis strategy to achieve demanding goals.
  • Making tasks in background like console applications to populate dinamyc information for accounting process.

dba

  • Oracle, MSSQL and Postgres database routine management and improve administrative efficiency with Nagios core and my plugins.
  • Oracle RAC 12.2 on HPUX and RedHat Implementation.
  • Oracle 18c upgrade and data migration from 10gR2 with Golden Gate between Data Center.
  • SQL Server DB migration between Data Center using LogShipping.
  • Oracle RAC 12.2  on HPUX data migration between Data Center  using storage sync .

dba

  • Analysis and optimization of databases 
  • Migration from SQL 2000 and 2008 to SQL 2012 
  • Creation and establishment of backup policies and information protection 
  • Automation of processes 
  • Creation and analysis of audits files

dba

  • Copying the database objects from prod to Dev using exports/imports and datapumps.
  • Experience in Database point in time recovery for restore the missed objects.
  • Working on DB link and MView refresh issues.
  • Resolving the archive gap in between primary and standby.

dba

  • Create and enforce database development standards.Develop load-balancing processes to eliminate down time for backup processes.
  • Configured Oracle Enterprise Manager Grid control for monitoring to manage and automate the alerts based on thresholds. Utilized OEM components (Diagnostics Pack, Tuning Packs, and Change Management Pack) for analyzing the database activities and improving the performance 
  • Performed performance tuning of the database for the accepted level using Broad brush approach (tuning of Design, Operating system, Database, Instance, Disk I/O and Application). Implemented database performance monitoring tools 
  • Supported users and developers; developed queries; and optimized their stored procedures