Software Analyst Resume
Profile
Versatile IT professional with expertise in software analysis and database administration. Record of performing well in call center, quality assurance, and development environments. Resourceful problem solver. Adept at interpreting business needs and creating effective solutions. Analytical, conscientious, and committed to excellence.
Certifications
- Linux+
- Oracle 10g I Certified Associate OCA
- Oracle 10g II Certified Professional OCP
Technical Expertise
Operating Systems Windows9x, NT, 2000, ME, SP, 2003, Server, XP and Professional, Ubuntu, Red Hat, Oracle, Linux
Software Applications SQL Server 2005, Oracle, Citrix, PC Anywhere, Microsoft Office Suite Apps, Gedit, X Window System, GNOME, GNU
Databases Alpha 5, SQL, Oracle9i, Oracle 10g, Linux, OLTP(Master Data)
Technical Expertise
Technical PlanningDatabase Management
Application Development
New Release Management
Test Design & Execution
Performance Tuning
Technical Documentation
Customer Relational Databases
Knowledge Administration
Implementations & Upgrades
User Training & Trainer Support
Back-Ups & Restorations RMAN
Professional Experience
ORACLE 10g
- Installed and created databases, tables, tablespaces, indexes and materialized views.
- Created users assigning default tablespaces, quotas, roles and profiles.
- Used ADDM (Automatic Database Diagnostic Monitor) to monitor, analyze data and identify potential performance issues.
- Managed database performance by collecting performance statistics and reports with AWR(Automatic Workload Repository) capturing wait events and resource intensive SQL statements, object usage stats and system and session stats. Tuned SQL statements using the SQL Tuning Advisor Tool. Identified segments with unused space and reclaimed segment space using the tool segment advisor.
- Used OEM(Oracle Enterprise Manager) to set database availability states to receive notifications on metrics and policy settings.
- Used RMAN to perform backups and recover. Flashback feature used to restore from errors.
- Oracle (Flashback Version Query, Rollback, SQL, PL/SQL, SQL coding familiar, ASM). RAC,SAN, Veritas, partition and replication highly interested in becoming familiar.
Confidential Atlanta, GA
Software Analyst II (11/2002 – 5/2008)
Database Management
- Partnered with Quality Assurance and Development staff to design and build databases. Upgrade, tune and perform maintenance of 250+ databases.
- Performed security administration, adding and removing users while giving access to levels of use.
- Mentored technical support specialist and technical support analyst representatives.
- Tested, verified, and resolved fixed defects in finished product or update patches.
- Modified and customized table structures, forms, and views within databases. Developed and performed daily maintenance, indexrebuilds and recompiles on relational databases. Installed databases, new software and performed recovery operations on failed databases.
Application Development
- Researched and created solutions to complex product-related issues.
- Contributed to software maintenance release planning.
- Planned and directed application design, development, and maintenance.
- Provided input for selection of beta sites and participation. Verified release notes and product specifications. Anticipated issues with new releases and suggested solutions to management.
- Developed FAQ (Frequently Asked Questions) and TSB (Technical Support Bulletin) communications for NSP (Network Service Providers) and internal use with support.
- Tested and recommended new products to increase functionality, product usability and supportability.
- Selected to serve as chief technical officer of the OMSComp product, managing daily operations, supporting system infrastructure, and performing software sensitive upgrades, OLTP.
- Continuously assessed business needs, determined solutions, oversaw testing of new technologies, and evaluated test results to facilitate product enhancements and advancement of product knowledge.
Confidential, Norfolk, VA
Technical Support Computer Specialist Level II (5/2001 – 5/2002)
Supported clients and staff, division wide. Conducted management system testing and other testing concerning Verizon Internet applications. Configured clients email accounts.Diagnosed and resolved DSL connectivity issues.
ConfidentialNorfolk, VA
MicroComputer Specialist (5/1999 – 9/1999) Internship
Provided comprehensive hardware/software services, including support for 350+ users, installations, upgrades, troubleshooting, and development of technical strategies.
Education
Certificate: Database Administration ( Linux+, OCA Oracle 10g I, OCP Oracle 10g II)
Bachelor of Science: Biology/Chemistry
Major: Systems Engineering,