Database Administrator/ Data Analyst Resume
2.00/5 (Submit Your Rating)
Mesa, AZ
SUMMARY:
- Oracle Certified Professional (OCP) with 10+ years as an accomplished database administrator, Oracle developer, database security and application server administrator, and system administrator, with experience combining technical and business solutions to support corporate strategic goals.
- Flexible team player with solid project management and communication skills, able to respond quickly to changing priorities and complete tasks and projects within tight timelines.
- Able to leverage operations and technology to achieve business objectives.
AREAS OF EXPERTISE:
- Database Administration Oracle Forms & Reports Infrastructure Design & Architecture
- System Configuration Database Security System Migration Planning
- Technical Standards Application Administration Database Backup & Recovery
- Change Management Complex Problem - solving System Monitoring & Maintenance
TECHNICAL SKILLS:
Experienced with Oracle 9i, 10g, 11g, 12c, MSSQL, Azure, MYSQL, Oracle Enterprise Manager (OEM), Tuning & Optimization, Load Balancing, Dataguard, RAC, Golden Gate, Shell scripting, SQL, PLSQL, TOAD, Workbench, SSMS (Solaris, Unix, Linux, windows OS)
PROFESSIONAL EXPERIENCE:
Confidential, Mesa, AZ
Database Administrator/ Data Analyst
Responsibilities:
- Responsible for installing, upgrading and configuring MSSQL environment Create, debug, and manage complex dataflows and data mappings for the new database.
- Use statistical methods to analyze data and generate useful business reports
- Work with departmental managers to outline the specific data needs for each business method analysis project
Confidential, Scottsdale, AZ
IT Supervisor
Responsibilities:
- Implement strategies for IT operations, providing outstanding software, hardware, and server support to 30+ staff at three locations - Montreal, Toronto, and Scottsdale.
- Conduct research on all technological solutions and provide support for procurement procedures. Maintain knowledge of the latest software and operating system updates.
- Ensure compliance with all deadlines, and provide upgrades to systems per requirements.
- Analyze IT infrastructure and prepare reports for senior management.
- Prepare orientation programs for new employees and supervise IT staff.
Confidential
Database Administrator
Responsibilities:
- Worked collaboratively with team members to ensure the integrity of the Corporate Information Security, Infrastructure Support, and Information Systems business units.
- Recommended solutions and implemented upgrades to systems and servers in order to optimize load balancing for application server, particularly during times of heavy usage by 10,000 users.
- Performed installation, upgrade, and configuration of Oracle binaries and created new databases, consistently ensuring accurate, on-time completion of project deliverables.
Confidential
Database Administrator
Responsibilities:
- Key Accomplishments: Upgraded Oracle Database 8 to Oracle Database 11g.
- Created standby database data guard for the entire university, and worked with team members on installation of Oracle application server.
- Received recognition from managers and users for initiative and excellent problem-solving skills.
- Developed and tested storage strategies and disaster-recovery plan
Application Administrator
Confidential
Responsibilities:
- Performed troubleshooting, load balancing, clustering, application deployment, performance tuning, and maintenance in order to maintain smooth operational flow with zero downtime, leveraging knowledge of Oracle and Point base servers.
- Created, configured, and tuned WebLogic domains/applications for optimal performance. Monitored the WebLogic server using spotlight agent-based monitoring, configured web server plug-ins for application servers, and provided 24x7 support for the WebLogic server.
- Analyzed Log Files, Confidential, JVM Dumps, and Exception Stack Traces.
- Configured Site Scope monitors in order to monitor the environment.
- Actively participated in configuration management, software deployment, change management, performance monitoring, and application maintenance.
Oracle Forms Developer
Confidential
Responsibilities:
- Worked on all in-house systems developed within the university, including monitoring, maintenance, new system development, and integration with other systems.
- Collaborated in major upgrades from Dev. 4.5, DB 8i to Dev. 10.3, DB 11.1.6i .
- Created connection form with Vasco security system using SOP protocols.
- Migrated Oracle forms and reports from Oracle Forms 4.5 to Oracle Forms 10.
- Performed troubleshooting and configuring of forms created by the in-house development team. Managed and tuned forms and reports using PLSQL scripts.
- Assisted system teams in planning and production of disaster recovery site