PROFESSIONAL SUMMARY:

• An accomplished database administrator (DBA) with 6 years of extensive experience in testing, and supporting next - generation database solutions in Oracle Enterprise and SQL Server environments.
• Exceptional written, verbal, analytical and organizational abilities; proven leader with a highly motivational style, a solid reputation for building and highly motivated teams and development of innovative solutions; results-oriented self-starter with an excellent track record for identifying opportunities for accelerated growth; dedicated team player who listens, thrives on collaborating with diversely talented team members, and integrates their divergent thoughts, opinions, and perspectives into meaningful action; energetic, competitive achiever who can manage multiple priorities and perform under pressure in a fast-paced, rapidly changing environment, global thinking who is degreed in management and adept at training, developing, human resources, and coaching team members and clientele.
• Dedicated to quality, innovation, engagement, integrity and inclusion.
• Skilled in designing and implementing complete life cycle client servers and database applications with various development tools and languages.
• In-depth understanding of security and backup procedures to ensure database integrity.
• Experienced in Data Redaction and Data Encryption using Oracle TDE or wallet to protect the organization’s critical information and exceeding the industry standard.
• Experience with various tools, such as SQL*Plus, Oracle Streams, SQL Developer, Oracle Enterprise Manager (OEM), Recovery Manager, and Oracle Secure Backup.
• User management, creation, monitoring and administration of database users; altering passwords and granting/revoking access to system/object privileges, roles and auditing user actions.
• Monitoring, Sizing & Reorganization of Tablespaces/Tables/Indexes.
• Agent and listener control.

TECHNICAL EXPERTISE:

Operating Systems: Linux, RHEL 6 and 7, Sun Solaris 10 and 11, Windows 2003, 2008 R2, 2016 Server.

Database Management: OEM 9.2/10G (10.1/10.2), RAC

Databases: Oracle 11g, 12c, SQL Server 2005, 2008

Tuning/Monitoring: Clustered Databases, Data-Guard 9i/10g/11g, DB Cloning, Standby Databases, RMAN 11g,12c, EXPLAIN PLAN, Solarwinds DPA.

Tools/Utilities: RMAN, OEM 11g, 12c Oracle Management Server, SQL *Plus, SQL Server 2012,2016, Export/Import, Data Pump, Toad, Oracle Streams, PuTTY

Applications: Evisions, Ellucian Banner ERP, Theia by Motio, Clockwork, PLPDF

PROFESSIONAL EXPERIENCE:

Database Administrator

Confidential, Denver, CO

Responsibilities:

• Create and maintain Oracle and SQL Server databases required for development, testing, and production usage. Install, configure, and administer Oracle WebLogic Server and other application servers.
• Perform ERP, Data Warehouse, and other Administrative software installs, upgrades, and patches.
• Work closely with system administrators to implement storage and capacity planning for new and existing databases and applications.
• Plan and implement backup and recovery strategies for databases and applications.
• Analyze, consolidate, and performance tune database and application servers for optimal efficiency.
• Monitor databases and applications for availability. Provide 24/7 support for critical situations on an on - call basis.
• Follow enterprise standards to apply requested and approved modifications to database structures, data, and applications.
• Manage complete project lifecycle. Effectively communicate project status with direct supervisor and project own.
• Software implementation, support, and development
• Secure access to institutional information
• Database development, administration, Data interfaces and Document Management
• Workflow solutions
• Business Process analysis and improvements
• Consultation with DU departments on software development or purchase
• Data Warehouse administration, reporting and data mining
• Business Intelligence, Advanced Analytics, and Dashboards
• Ensures the current and future software applications are efficient and effective, maintains an appropriate balance between leading-edge activities and core business processes, and provides appropriate information access and data security.
• Responsible for all aspects of the Enterprise Resource Planning (ERP) system, Database Management, Data Warehouse administration, Information Analytics (BI), Customer Relationship Management (CRM) systems, Learning Management System (LMS), Document Management and Workflow.

Oracle Database Administrator

Confidential, Houston, TX

Responsibilities:

• Maintained all existing databases and new installations at current and stable production levels.
• Configured, installing and administratingoracledatabase systems
• Interact with MyOracleSupport regularly regarding open Service Requests
• Tuning of SQL queries to troubleshoot and resolve database or application problems encountered by end users.
• Monitor database health or generate alert log, AWR or ADDR to perform tune up and resolve database performance problem.
• Proficiency in Disk management and problem resolving techniques with a good understanding of Capacity.
• Performance tuning of theOracledatabases and SQL queries by analyzing the EXPLAIN PLAN to improve the performance of the database and application end users.
• Analyzed database performance and tuned database withOracleand SQL Explain Plans.
• Plan and install change control, verification of system resources, backup and recovery, disaster planning, performance tuning and troubleshooting
• Partitioning Table to increase performance and using Advanced Compression.
• Evaluated database performance for investigation of issues and further resolution for efficiency.
• Involved in performance tuning and database reorganizations.

Junior Oracle Database Administrator

Confidential, Greenbelt, MD

Responsibilities:

• Handling day - to-day activities and resolving tickets using remedy tool.
• Database administration of theOracledatabase System.
• Performing Backup/Recovery of all theOracledatabases using RMAN.
• Performing all the Database Administration activity like space management in database, user and roles administration, schema management, checking alert log of all the databases
• Involved in the process of tuning and refining queries of various applications.
• Involved in the process of exploring new areas ofOracleand its products.
• Daily database backup, table space administration, SQL and basic database tuning as part of maintenance activities.
• Maintenance of existing system and provided advanced level support.
• Involved in System study, Analysis, Design and Development.
• Developed back-end Stored Procedures, triggers, functions.
• Worked on import/export and SQL*loader.
• Proficient in OEM tool.
• Have knowledge of RAC, ASM, DATAGAURD.