Database Administrator Resume
Reston, VA
INFORMATION TECHNOLOGY
Motivated, forward-thinking, performance-driven professional, with breadth of backgrounds, and deep competencies for providing high-quality technology solutions and services to end users/client’s satisfaction while contributing significant impact to maximization of corporate values. Demonstrated strengths to perform independently and the ability to nurture partnerships ensuring success in delivering results. Offering capabilities for state-of-the art technology implementation for quality assurance, installations, configurations, documentations, testing, training, troubleshooting, and research. Aligns financial analysis/sales proficiencies based on Service Level Agreements (SLA) to the requirements of that set Company.
TECHNICAL SKILLS
Adobe Acrobat. Visio. Internet Explorer. Microsoft Access. Microsoft Excel. Microsoft Power Point. Microsoft Project. Microsoft Word. Microsoft Project SQL. Cute FTP TOAD. Workstations. Network Infrastructure. Outlook. UNIX. Linux. Solaris. Windows 98. Window NT and XP environment . Backup packages. Database & Tools: Oracle 10gR2/11R2g, OEM, Oracle Diagnostics & Performance Pack, Oracle RAC, DATA Guard, DataPump, SQL*Loader, OUI, DBCA, RMAN, FLASHBACK, SQL/PL/SQL, LISTENER.
TECHNICAL CERTIFICATIONS AND EDUCATION
ASSOCIATE DEGREE IN INFORMATION TECHNOLOGY PROGRESS
PROJECT MANAGEMENT CERTIFICATION (PMP)
KELLER GRADUATE SCHOOL OF MANAGEMENT PROGRESS
ORACLE CERTIFIED 10G/11G PROFESSIONAL
MAXAUR DBA TRAINING CENTER, RESTON, VA APRIL 2009
BSC. IN GEOGRAPHY AND MINOR IN MARKETING
BUSINESS SUMMARY
- Led various initiatives and teams to improve data center capabilities, reduce costs, and develop applications to grow business opportunities & profit.
- Mentored numerous individuals into leadership and account management roles.
- Managed various technology engineering, systems development, operations and project teams.
- Experienced in data center planning, development, global sourcing, contract management and business application integration.
- Strong experience with identifying key technology deployments, business partnerships and development initiatives to maximize business cash flow and revenue/profit growth.
EMPLOYMENT PROFILE
Confidential, Reston, VA 01/2011 - 5/2012
Database Administrator (Oracle)
- Responsible for Designing/creating and maintaining client databases as well as, processing data for Oracle databases.
- Managed project resource allocation for team members and oversaw responsibilities, workflow and dependencies between processes.
- Maintained servers and services ensuring stability and minimized possible service downtime. Monitored, maintained and repaired production databases
- Communicated with internal/external clients to define requirement, organization, and management of evidence and case data.
- Define, communicate and manage project scope, notify team of client-requested updates and or changes to project scope.
- Work with Application Developers and Data Architects to design/create new Oracle databases/create new schemas/database objects, as well as making database changes following requests/demands from the development team
- Monitor database systems and provide technical support for database system issues and application performance enhancement/improvement using both Oracle 10g Enterprise Manager Grid Control and DB Console, Oracle 10g Enterprise Manager Client Console, TOAD for Oracle & SQL*Plus.
- Worked closely with UNIX/Linux System/Storage Administrators to Configure, Implement & Deploy Oracle Single Instance 10gR2 (10.2.0.4) and 11gR2 (11.2.0.1) on AIX 5.x and RHEL5.x using file system
- Backup/Recovery Configuration of Oracle 10g/11g single instance/RAC databases using Oracle
- Monitoring rollback segments, Adopting proactive maintenance strategies to curb extensive shrinking and wrapping of rollback segments
- Data loading using SQL*Loader and Impdp &Expdp, External table to assist Data loads with developers.
- Utilized Oracle 10g Flashback Features to ensure 5 day retention time for any object that is removed from the production database.
- Performed recovery from missing or corrupted data files, redo log group, control files and recovery from block corruption (dbverify).
Confidential, Washington, D.C 12/2009 - 12/2010
Database Administrator ( Oracle)
- Performed successful & periodical Backup, Restoration & Tuning.
- Upgrading of Database from lower version to higher version.
- Work with System Administrators (Unix & NT) to ensure Oracle related matters are handled properly.
- Diagnose, troubleshoot and resolve any DB related problems. Work with Oracle Support if necessary to bring problems to a successful resolution.
- Responsible for overall strategic planning & redesign of databases: Requirements gathering and Analysis, Design, Test and Implementation through the phases of System Development Life Cycle.
- Worked with application developers to address and clarify data requirements to resolve technical and functional issues by enforcing corporate business rules through adequate user/resource/object management.
- Reconciled functional and technical problems through interaction with clients by researching and identifying the defined issues and by fully testing and confirming possible solutions to the problems encountered.
- Part of a team responsible for a 7 x 24 Oracle database operation involving wireless market data collection.
- Monitored server performance, database and transaction log growth and error logs.
- Configured listeners and tnsnames using net manager and/or net configuration assistant.
- Established capacity planning of tablespaces, tables, indexes, and databases to allow for growth potential.
- Created Analyzed database objects tablespaces, Application Users, Database schemas, profiles, granting privileges and roles, and database links.
- Established, designed, tested and implemented backup and recovery solutions including automated daily hot/cold backups depending on criticality of the Database - (RMAN, EXP/IMP PUMP and shell scripts) and database migration.
- Provided performance tuning activities for Oracle database improvement. Tuned database through initialization parameter, SQL statement, and memory by performing routine checks of the SGA, CPU, logical and physical I/Os and contention.
- Security implementation through basic and advance security techniques like applying recent Critical Patches and upgrades, appropriate user grants, permissions and profile management.
- Utilized PL/SQL for programming and Stored Procedures especially enhancing capabilities to SQL.
- Restructured, tuned tracked, proactively monitored database load, fragmentation, contention, and overall performance for optimal performance of the existing database.
- Monitored database growth, created objects, administered users and tuned expensive SQL statements using EXPLAIN PLAN and SQL TUNING ADVISOR.
- Replicated Databases, using database links, streams for disaster recovery and cloning.
- Implemented database migration from 10g to 11g using data pump utilities
Confidential, Arlington VA. 09/08 - 11/2009
Sr. Data Entry Specialist/Analyst
- Provides supervision and technical support for the DoD/Military and AmeriCorps/Vista Online application databases.
- Checks data from completed forms or other documents for accuracy and completeness and enters into database
- Reviews audit reports and resolves errors to ensure integrity of data
- Identifies problems with database management policies and procedures and provides input into their revision
- Identify problematic areas and conduct research to determine the best course of action to correct the data
- Analyze and problem solve issues with current and planned systems as they relate to the integration and management of patient data (for example, review for accuracy in record merge,
unmerge processes)
- Analyze reports of data duplicates or other errors to provide ongoing appropriate interdepartmental communication and monthly or daily data reports.
- Monitor for timely and accurate completion of select data elements (for example, verbal
- physician orders)
- Identify, analyze, and interpret trends or patterns in complex data sets
- Monitor data dictionary statistics
- Work as a liaison officer between the Military Families and Child care providers.
- Assist Coordinators with clarification of policies and procedures and handling the day-to-day application process.
- Monitor call center log-ins and activity and ensures that Coordinators follow up on calls from their voice mail and general voice mail. Monitors Coordinators\' caseloads and backlogged cases.
- Ensure that Coordinators follow up on forwarded emails, ensures faxes are logged and distributed in a timely manner.
- Ensure that incoming supporting documents are assigned in a timely manner and ensures that files, documents, and attendance records are filed correctly and in a timely manner.
- Establish and monitor alerts for actions that are time sensitive and past due and assists Coordinators with processing backlogged applications.