Senior Database Administrator Resume
5.00/5 (Submit Your Rating)
Bothell, WA
SUMMARY:
- Senior Oracle and noSql (MongoDB) Database Administrator and Solution Architect possessing 10+ years of IT industry experience.
- Performed Capacity Planning on various database environments.
- Provide support to DevOps on Skytap / AWS cloud
- Operational support to various deployments.
- Develop solutions based on RDBMS and Big Data databases
- Troubleshoot various database (RDBMS and noSql) problems / issues
- Providing metrics, trend analysis, and recommendations
- Investigate and provide thought leadership into leveraging cloud - based solutions
- Consults with development and test teams around best practices for storage efficiency and performance
TECHNICAL SKILLS:
- Oracle 12.2 / 11.2.3. x / 11.2.0.4.x Internals / Oracle Enterprise Linux 7 / Oracle Enterprise Linux 6
- Oracle Real Application Clusters (RAC) / Oracle cold cluster
- Oracle Data Guard
- Oracle ASM
- Backup and Recovery using RMAN
- Database Design
- Performance Tuning
- Data replication
- Data Modeling
- Oracle cold cluster (OCC) HA solution.
- NoSQL / Mongo DB / MySQL / Postgres / Cassandra Admin
- Data Warehousing
- Database Security
- Oracle Enterprise Manager (OEM)
- Unix Shell Scripting
- PL/SQL
- Perl DBI
- Unix, Solaris, HPUX, AIX, Linux (OEL)
- System Design
- Release Management
WORK EXPERIENCE:
Confidential, Bothell, WA
Senior Database Administrator
Responsibilities:
- Production DBA Support for a number of customer facing 24x7 Large Oracle Database environments including Insurance agency apps named BenefitPoint online portal, ETL (Broker content extracts) and Oracle application Gateway databases.
- Created and maintained all databases required for development, testing, education and production usage.
- Performed the capacity planning required to create and maintain the databases.
- Performed ongoing tuning of the database instances.
- Installed new versions of the Oracle RDBMS and its tools and any other tools that access the Oracle database.
- Planned and implemented backup and recovery of the Oracle database.
- Provided metrics, trend analysis, and recommendations to management team to enable them to make informed decisions regarding resource management.
- Implemented and enforced security for all of the Oracle Databases.
- Performed database re-organizations as required to assist performance and ensure maximum uptime of the database.
- Troubleshooted problems regarding the databases, applications and development tools.
- Analyzed and reports the performance of database operations against the key database performance metrics
- Architected an Confidential internal ETL solution called Broker Content Extract.
- Managed key database migration projects from 10g to 11g with Oracle TDE (Transparent Data Encryption) and most recently into Oracle 12c.
- Implemented High Availability solution for Agency Products such as BenefitPoint using Oracle Standby / Oracle cold cluster methodology (OCC).
- Successfully Planned and Implemented Quarterly Oracle PSU Patching.
- Provide DBA support to Dev Ops teams on Skytap and AWS cloud.
- Worked with Application Development / Deployment / Hosting Infrastructure teams in successfully deploying new application releases which led to 200% increase in BenefitPoint sales over 3 years timeframe.
- Architected MongoDB based application called Confidential Agency content (image) management system (CMS).
- Installation of Mongo/noSql software 2.9 thru 3.4 versions and setting up replicaSets.
- Monitored databases using Mongo MMS cloud service.
- Setup MongoDB backups using MongoDB cloud backup service.
- Helped the team to succeed by teaching them MongoDB skillset.
Confidential, Bellevue, WA
Sr. Database Administrator / Consultant
Responsibilities:
- Worked on a Database migration and modernization team at Boeing company.
- I was directly responsible for DB/App migration activities between Data centers which includes meet customers on a daily basis, come to agreement on DB and App migration plans/paths, create and establish test environments for testing the DB/App migration and plan and execute migration of Production DBs between Data Centers.
- DB migration included a number of flavors of Operating Systems and DB versions.
Confidential, Bellevue, WA
Sr. Systems Analyst (IT) / Sr. Database Administrator
Responsibilities:
- Production DBA Support and DBA Point of contact for a number of 24x7 Very Large Oracle Database environments with terabytes of data including Wireless Billing, B2B online website and Data Warehouse systems.
- Performed various database administration duties such as
- Space monitoring and Tuning Storage parameters.
- Database capacity planning.
- Monitor and administer User processes using UNIX scripts and OEM grid control.
- Pro-active database session monitoring and tuning.
- 24x7 Production DBA on-call support and timely resolution of severity tickets.
- Oracle software installation, Database creation.
- Plan and implement Oracle Software version and Database upgrades.
- Research, plan, communicate and help implement, track various oracle database initiatives across DBA team.
