Sql Server Oracle

Technical Skills:

Oracle:

Oracle *i, *i, **g, 11gR2, 12cRAC ODA.

RAC,CRS, Veritas Clustering, ASM, 12c multitenant PluggableDB, 13c OEM.

Active Data Guard 11gR2, Physical/Logical Standby, database. DBVisit. Database Replay.

Golden Gate, Streams Replication, GRID, Veridata Server, GDS.

RMAN, FRA, Datapump, exp, imp. Veritas Net Backup.

DBCA, DBUA, TOAD, SQL developer, SOX.

Capacity Planning, Advanced Queueing, Martialized Views.

AWR, ASMM, ADDM, ASH, SGA, TkProf, Explain Plan.

SQL Loader, ETL, Hyperion Brio, UNIX shell scripting, PL/SQL, Triggers.

Data Modeling, ERStudio, DBArtisan, Erwin.

TDE, Oracle database Vault.

Exadata, ODA, Oracle VM.

VPD, Table Partitioning, VCP.

Windows and Linux Servers.

VMware and Virtual servers, Oracle VM.

MySQL 5.5, 5.6, 5.7:

InnoDB, MyISAM, CSV.

MEM,Nagios, MEB, mysqlbackup, mysqldump.

MonYog, SQLyog, TOAD, MySQLworkbench.

Master – Master, Master – Slave replication, HA Proxy.

NDB Cluster, Galera Cluster, MySQL Enterprise Auditing.

mysqlslap, mysqlcheck, myisamchk, myisampack, sysbench, profiling, events, query cache, DB upgrade.

Migration of Data (MySQL, Oracle, SQL Server).

Data Migration Services (DMS)

Percona Toolkit, Data Partitioning.Autosys, Jenkins.

MS - SQL Server:

(2000, 2005, 2008R2, 2012)

SQL Server Enterprise Manager (SSEM), SQL Profiler, SQL Query Analyzer.SSIS, SSAS.

Snapshot/Transactional/Merge replication

Failover Clustering, Database Migration, Upgrade.

Database mirroring, High Availability, T-SQL.

Amazon Web Services (AWS):

Oracle, MySQL RDS, EC2 instances.VPC’s.

Data Migration Services (DMS)

S3 Client Setup, S3 bucket setup.

Operating Systems:

Windows Server 2003, 2008,AIX5,IBM AIX UNIX Servers

Solaris 9, 10.

RHEL 4, 5, 6, 7

Communication & Networking:

FTP, SFTP, Core FTP, SCP

SSH, Putty, FileZilla, Telnet, VNC

Skills:

IT Project Coordination

Visio, Microsoft Excel

Organizing

Analytical Thinking

Vendor Coordination

Change Management

Data Center Support

Negotiation Skills

Andy Singh

Sr. Oracle/MySQL DBA

682 S Laveen Dr. Chandler AZ 85226 602-***-****

Email: acz2pq@r.postjobfree.com

Qualifications:

13 plus years’ experiencein all aspects of Oracle Database administration.

Over 7 Years of experience in MySQL Database administration.

Over 8 Years of experience in MS-SQL Server database administration.

Extensive knowledge in Installation, Configuration, Backup Recovery and Tuning of all kinds of databases Oracle, MySQL and SQL Server.

Expertise in 11g, 12c RAC for High Availability and Data Guard.

Extensive knowledge of Performance Tuning of all kind of databases using various tools.

Expert in managing Security of databases.

Extensive knowledge to troubleshoot Windows and Linux problems.

Excellent organizational and time management skills.

Demonstrated ability to research and consolidate information.

Programming languages (C, C++, Java, Visual Basic, HTML, PL/SQL).

Experience:

American Express, Phoenix. July, 2016 – Present

Oracle RAC / MySQL DBA.

Installation, Configuration of 12c RAC in Linux environment. Managing/Supporting ODA / Exadata environment, 12c Golden gate, 12c Veridata Server Installation, Oracle Dataguard Configuration, configuring multitenant databases, upgrade 12c OEM to 13c OEM, installing agents, discover targets and adding targets to 13c OEM. Blackout/Remove Troubleshoot targets, applying patches node by node in shared ODA environment. POC PostgresSQL 9.x and Cassandra for upcoming projects, UNIX shell scripting, configuring RMAN backup Jobs. Installing new Oracle 12c home to move/upgrade 11g database to 12c. OEM VIP agent installation, performance tuning and monitoring. Installing/Configuring MySQL 5.6 and migrate from OS RHEL 5.0 to RHEL 7.0. Exdata experience, oracleasmlib installation, Move non-CDB to CDB. SR opening with Oracle support and follow up.

Matson Navigation, Phoenix May2007 – July 2016

Sr. Oracle / MySQL / SQL Server DBA.

Performance Tuning production, test, development databases, hit ratio monitor, database buffer, redo buffer, tuning SQL using explain plan and virtual indexes. Scan AWR, STATSPACK report, Unix shell scripting for database monitoring and backup. Setup RMAN physical backup and logical datapump backup, cronjob setup, Oracle 10g Installation on RHEL 5.0 and Windows 2003. OEM setup. Capacity planning, automate alert log monitoring. SQL trace, 10046 trace, DBMS_SUPPORT, Gather STATS, optimizing queries. Schema refresh from Prod to dev, Database upgrade from 9i to 10g on windows and Linux. Database cloning using RMAN. Materialized views for data refresh, Database design, physical and logical database modeling using ER Studio. Analyze view query code before moving to production, space management, undo management, TSPITR. Security implementation using VPD. Database Auditing using logon trigger, On call support rotation. SQL Loader use to load data, configured MGW to sync DB2 and Oracle 10g, Opnet Panorama tool and alert setup for different database metrics. Installed Configure MySQL 5.5, Upgrade MySQL. MySQL replication (master – slave) and master – master using Galera Cluster. MEM setup, MySQL Physical & Logical backup setup using MEB and mysqldump, Migrated Oracle / SQL Server databases to MySQL. SQL Server installation / Configuration Failover Cluster on Windows 2008. Used DBvisit Standby Dataguard solution for Oracle SE. Configure Golden Gate replication in heterogeneous environment from Oracle to MySQL. Write Unix shell script to scan MySQL general query log for auditing purposes.

Vicor Corporations, Andover MA Jul 2006 – May2007

Sr. Oracle DBA.

Installing/Configuring Oracle database on Solaris, RHEL, Windows Server 2003, Configure ASM on raw devices. Experience working on Data warehousing and OLAP databases versions 9.2.0.6 and 10g. OEM setup and configure alerts. Session tracing using DBMS_SUPPORT for tuning, SQL Query optimization using TkProf, explain plan and adding indexes. Work with developers on schema design and tuning. Analyzing STATSPACK reports. Setup RMAN physical backups and Export / Import for logical backups. Performed point in time recovery using RMAN, Dev database refresh using cold copy, introduces FK to maintain database Integrity. Quest Central tool TOAD for tuning and modify DB objects. Automate schema refresh using UNIX shell scripts. Maintained cronjobs, Recovered Block corruption using RMAN. Automate scanning alert log and email if any error. Configured Physical Standby, Capacity Planning and on call Rotation. Participated in daily performance calls and resolve various database related issues. Tablespace Alert setup. Setup a cronjob to Cleanup old trace files. Worked with Oracle metalink to resolve various issues, applying patches to fix bugs.

Sprint Kansas, Overland Park Jan 2005 – Jul 2006

Oracle DBA.

Database design, Analysis and build, implement RAC on 10gRel 1 on RHEL 4. Maintaining and supporting very large Oracle databases 10g, 9i and 8i on 24x7 basis. Created various logical standby databases for reporting purposes. Implement Oracle Flexible Architecture (OFA). DBMS_JOB setup for analyzing Oracle tables on daily basis. Query Tuning using TkProf, explain plan. Setup Physical and Logical database backup using RMAN and exp/imp respectively. Manual database upgrade from 9i to 10g and using DBUA. Created various databases using DBCA. Setup Stream replication. On demand dev database refresh from production. Database job automation using UNIX shell scripts. Schema design and help developers on query tuning. Better space management using locally managed tablespaces. Undo management, capacity planning, performance Tuning. Configured RMAN tape backup using VERITAS Net backup. Provided documentation on assigned databases and project planning, physical and logical database design. On call support rotation 7x24x365.

Boston Medical Center, Boston May 2004 – Jan 2005

Oracle DBA.

Installed, Upgraded and Configured Oracle (8.0.5, 8i, 9i). Setup RMAN, configured database events and monitor database alerts. Schema compare using TOAD for application development. SGA Tuning including database buffer and redo log buffer, monitoring hit Ratio and analyze STATSPACK, worked with BLOB, CLOB, materialized views, Server Tuning, Defragmentation of tables, index rebuild, cloned databases, setup OEM, database sizing, tablespace management, removed row chaining for better performance, Table Partitioning. Advanced replication setup. Unix shell scripting to shutdown/startup databases automatically.

Rolex Fire Systems, India May 2002 – April 2004

Database Analyst.

Worked as Production Support DBA for Oracle based Systems on UNIX. Designing, creating, configuring Oracle 8i databases. Enforced security by creating roles, granting table privileges. Setup Physical/Logical backup and monitoring databases. SQL Loader to load data from flat files. Installed/ Created database using OFA. On call support 24x7, created various triggers and stored procedures PL/SQL. Database Migration & Upgrade.

Education:

MS (Information Technology) – India

BS (Computer Science) – India

MySQL Performance Tuning Training from Oracle Corp.

Introduction to Oracle 11g new features Training from Oracle Corp.

Awards:

Database Migration, Performance Tuning, Database Support, Exemplary teamwork AWARD from MATSON Navigation.

Contact this candidate