Database Administrator Resume

PROFESSIONAL SUMMARY:

Database Administrator with 6 years of experience in managing multi - terabyte databases, performance tuning, high availability, disaster recovery and backup & recovery on Oracle Database 12c/11g/10g and SQL Server .
Planned and implemented high availability and disaster recovery solutions such as Real Application Clusters and Data Guard on Oracle 11g and 12c.

TECHNICAL SKILLS:

RMAN: Systems: Windows Server, Oracle Linux, Red Hat Linux

Data Guard: Languages: C#, Shell Scripting, PL/SQL, T-SQL

Oracle RAC: Software: SQL Developer, PL/SQL Developer, Toad

Performance Tuning: Management: SQL Server Utility Explorer, Oracle Cloud Control

PROFESSIONAL EXPERIENCE:

Database Administrator

Confidential

Responsibilities:

Solved more than 20000 request/problem/change management tickets in 6 years under 1 hour and as a result, SLA limit lowered from 12 hours to 1 hour
Tuned inbound and outbound Oracle 11g IVR databases and decreased call durations between 10 seconds and 20 seconds per project
Consolidated 9 standalone Oracle 12c Standalone Database to 3 node RAC system and saved more than 50% license fee and freed hardware resources
Upgraded Oracle 11gR2 RAC & non-RAC databases to Oracle Database 12cR1
Implemented and managed Oracle Data Guard on both Oracle 11g RAC and Oracle 12c RAC systems
Installed and managed Oracle Grid and ASM & non-ASM file systems on Linux and Sun Solaris
Improved duration of ETL operations, Business Objects reports and backups more than 60% by archiving and compressing 7 TB data on Oracle Database 12c Data Warehouse
Created custom RMAN backup scripts and shell scripts for automated maintenance with crontab
Automated creation/refreshing of read-only database snapshots on 13 SQL Server mirror instance and reduced impact of I/O on production instances by redirecting all ETL operations and Business Objects reports
Participated in SOX audits every 6 months and passed every audit without an incident
Delivered SQL Optimization for corporate office employees
Supported teams and database systems on remote locations

Test Engineer

Confidential

Responsibilities:

Developed and managed system test plans, test strategy and system test cases based on requirements
Coordinated with software development to effectively respond to clients' changing needs
Participated in code design and code reviews to ensure performance best practices are embedded in the design
Evaluated and recommended appropriate actions where possible to improve the performance process and overall performance of the system

Digital Signage Specialist

Confidential

Responsibilities:

Marketed and advocated a specific audience using digital displays, including LCD, LED, and projection
Displayed digital images, videos, weather data, news, web pages, or text to increase brand recognition
Created custom reports and dashboards for server/client status, content versions
Managed and solved problems for 1000+ thin client on remote locations with LogMeIn
Administered SQL Server 2005 Database and FTP Server