Oracle Manager
Resume:
Liqin Xie
Newton, MA *****
*****.***@*******.***
*****.***@*******.*** 617-***-**** 158 Harvard Street, Newton, MASSACHUSETTS 02460
Senior Database Administrator
A result oriented Database Administrator with expert level Oracle. Extensive experience in monitoring, tuning and maintaining database performance to achieve optimal database efficacy.
Demonstrated success designing, developing and deploying complex production databases. In-depth knowledge in database backup and disaster recovery and business continuity planning. My experience is in full life cycle of Oracle databases starting from planning, installation of Oracle software, creating databases and then bring it to live in Production environments and then provide complete support of Oracle Databases, RAC clusters. I also explore new features of Oracle databases and realize complete return on Oracle investments.
Specialties
Oracle Grid Infrastructure (GI) and Database Planning Installation and Configuration of GI/RAC Upgrade to 12c from older version.
Oracle Database creation, Oracle Performance tuning, Backup and Recovery using RMAN. ASM Management and administration.
Installation/Configuration of Physical Standby Database and Active Data Guard.
Integrity of the Oracle databases
Automate database configuration using template, shell scripts and Puppet
Write a RMAN backup template script with the retention policy using shell scripts and Puppet for over 100 backup databases
Full life cycle of Oracle replication Shareplex starting from planning, installation, configuration and then bring it to live in Production environments and then provide complete support
Understand STATSPACK and AWR reports and assist the development team in identifying performance bottlenecks and made effective recommendations on performance issue
Technical Skills
Operating Systems: Microsoft Windows, Linux, HP-UX, VMWare, Oracle VM
Databases: Oracle Database 9i/10g/11g/12c; Oracle Real Applications Cluster (RAC), Microsoft SQL Server 2005/2008R2
Database Tools: OEM and Grid Control – installation, troubleshooting, maintenance
Oracle modeling, configuration, installation, DR/backup/recovery, patching, migration, tuning
Programming with PL/SQL and SQL, C, Perl, Unix scripting, Can use other languages with syntax reference
Oracle replication – including Multimaster, Shareplex, Streams, Data guard, Golden gate
PROFESSIONAL EXPERIENCE
Sr. Oracle DBA
AthenaHealth
October 2013 - recent watertown, MA
Responsibilities includes:
Manage and support hundreds of Oracle production databases (Primary, Standby, Development and Testing)
Response for all database issues and provide 24x7 on-call service
Search out and implement new technologies to continually simplify the environment while improving security, scalability, availability, and performance.
Support athenahealth’s Development, QA and Release Engineering organizations in both the US and India.
Document all database system components
Develop, manage and execute controls in support of athenahealth’s SAS70, Sarbannes Oxley compliance, including disaster recovery tests per our SAS 70 and SOX policies
Provide metrics to various internal and external customers to accurately measure the health of the databases
Monitor database activity and file usage, and ensure necessary resources are present.
Optimize database accessibility by developing load balancing/high availability architectures and processes to eliminate down time
Implement and support database security regulations, policies, and guidelines. Monitor security bulletins to obtain information of potential threats; install necessary security patches to ensure ongoing database security
Plan, test, and install upgrades/patches of Oracle software as necessary.
Administer, maintain, and implement policies and procedures for ensuring the availability, security and integrity of the Oracle databases
Develop and administrate backup and recovery procedures
Develop scripts for database monitoring and to automate routine tasks.
Perform data management tasks as required, such as loading, restoring and moving data to support our client implementation teams.
Tune SQL code and assisting developers in writing and tuning SQL queries.
Interact with Oracle support to resolve issues.
Automate database administration tasks using PL/SQL and shell scripts
Analyze database resource consumption, for problem avoidance and trend forecasting
Automate database configuration using template, shell scripts and Puppet for hundreds of databases
Perform basic and advanced tuning at the database and database/server level
Assist users with both basic SQL questions and sophisticated SQL tuning strategies
Use Enterprise Manager and other tools for availability and performance monitoring
Work directly with clients to plan and execute database outages and migrations
Wrote a RMAN backup template script with the retention policy using shell scripts and Puppet for hundreds of backup databases
Sr. Oracle DBA
Arbella Group Insurance
December 2011 - October 2013 (1 years 10 months) Quincy, MA
Responsibilities includes:
Manage and support hundreds of Oracle production databases (Primary, Standby, Development and Testing)
Response for all database issues and provide 24x7 on-call service
Perform basic and advanced tuning at the database and database/server level
Use Enterprise Manager and other tools for availability and performance monitoring
Work directly with clients to plan and execute database outages and migrations
Provide the FS layout and storage requirements to system administration team.
Got the functional user oracle created with right system permission.
Install Oracle binary software
Create new databases and configure the listener for primary and DR
Install Oracle Agent
Configure Oracle Agent
Wrote the script for CVS for supporting fail over procedures.
Automate database administration tasks using PL/SQL and shell scripts
Sr. Oracle DBA
Verizon
September 1998 - November 2011 (13 years 2 months) Boston, MA
Responsibilities includes:
Plan, Install and Configure Oracle GI (Grid Infrastructure) on Red Hat Linux Environments
GI upgrade to 11gR2 (11.2.0.2,11.2.0.3) from older versions of RAC on RHEL and Other Unix Environments
Installation and configuration of 12c, 11g,10g & 9i Oracle software on Unix and Linux Environments
Creation and configuration of single instance and RAC databases on Unix and Linux environments.
Plan, Install and fine Tune Golden Gate on multiple Databases in Production and non-production environments
Database upgrades from old versions to newest versions specially to 11gR2 and 12c
Oracle performance tuning and Query tuning and do analysis using AWR Framework
Database backup and recovery using RMAN (Recovery Manager)
Disaster Recovery and Planning and configure Physical Standby databases for Disaster Planning. Active Data Guard for Disaster and Reporting
Planning and installing Oracle Patches as per business requirements.
Provide rotational on-call (24/7) DBA support for mission and business critical databases.
Work with Oracle Corp. based on criticality of issues and be liaison till issues are resolved.
Performed troubleshooting of Oracle Internals (Memory, Dictionary, Optimizer, I/O contention)
Worked closely with dev team to clean-up the duplicate key data in the missing critical databases
Automate database administration tasks using PL/SQL and shell scripts
Reorganized several production and testing environments to reclaim storage and reduce disk I/O through various methods, including import/export, index rebuilds, and database rebuilding
Monitoring the Server Health Resources. Customizable metrics measure CPU, logical and physical I/O, transactions and memory utilization.
Monitoring the Real Time Sessions Within seconds and take immediate action on current performance problems.
Generated STATSPACK and AWR reports to assist the development team in identifying performance bottlenecks and made effective recommendations on performance issues
Developed UNIX shell scripts to automate routine database operations through the Oracle crontab & reduce redundant alerts to facilitate on-call rotation processes for other administrators
Monitored backups/resource utilization, granted and revoked user access, and audited database usage
Provided support in production environments with over 25 applications and 300 databases, operating on various technologies, such as data guard, SharePlex, Golden Gate replication, clusters, and data stream replication
Built, configured, and setup monitoring for several databases in a 4 node Linux RAC Grid environment
Converted RAC databases from one or two notes to four or five notes and so on
Performed database recovery using Oracle 10g/11g flashback to restore databases to previous points in time. That save eight to nine hours to re-build standby databases
Performed troubleshooting of Oracle Internals (Memory, Dictionary, Optimizer, I/O contention and so on)
Worked closely with production support and development to define database layout, replication, and storage management, backing up and restoring design requirements using Shareplex, RMAN, and DataGuard
Worked closely with dev team to clean-up the duplicate key data in the missing critical databases
EDUCATION AND AWARDS
B.S., Computer Science, Fudan University, Shanghai, P. R. China
M.S., Computer Science, University of MASS, MA
Contact this candidate