Database, System And Performance Analyst Resume
Durham, NC
SUMMARY
- Helping teams and people solve problems and advance solutions in the most impactful way in all database and related technology areas.
- Track record has been one of collaborating with many business areas and IT groups while utilizing a service focused approach to help solve IT challenges and bring together organizational goals and technology solutions.
- Known for being quick to adapt, responding to emerging database and IT challenges in order to deliver results and team success.
- Received various service recognition awards from peers.
TECHNICAL SKILLS
Database Platforms: DB2 8.1 through current versions. SQL Server last server versions, and Oracle at different times.
DB Tools and Extensions: DB2 Replication tools; HADR, DPF, Infosphere and Purescale familiarity. Some NoSQL DBs. Oracle PL/SQL. Utilities and systems tools of varying types. Performance and diagnostic tools of many types. Familiarity with ETL, DB Warehouses, Analytics. SQL Server clustering knowledge.
SQL Tools / Skills: Reading, rewriting, optimizing complex SQL and SQL procedures. Using and mastering SQL tools such as query planners, index advisers, plus using and integrating system health routines for tracking and reporting database health.
OS Platforms and Tools: Linux, Windows, Occasionally Others. Extensive scripting. Disk setups using NAS and SAN tools. Networking tools understanding. LDAP familiarity.
Database Security: Setup various DB security levels, plus OS security levels. Setup DB2 Auditing.
PROFESSIONAL EXPERIENCE
Confidential, Durham, NC
Database, System and Performance Analyst
Responsibilities:
- Facilitated rapid software releases, analyzed areas of code, integrated systems, and reviewed all database areas, identifying problem areas and providing corrections and tuning for diverse database builds running under web applications.
- Created and wrote tools and solutions for high volume databases systems, including SQL tools and procedures and other analysis in DB2, Oracle, and SQL Server. Built and applied shell, system utilities, and scripting languages and other tools.
- Troubleshot issues for internal and external customers, diagnosing functional and performance issues for complex application systems.
- Performed database systems building, Linux installs, and maintenance, application installs, setup, and tuning.
- Utilized stress and capacity test tools to critically understand system stability concerns, providing code and configurations solutions as needed.
- Set up and evaluated database scaling and failover systems, including determination of operational procedures and strategies. Provided solutions meeting consistently high uptime requirements and rapid upgrades.
- Performance tuning and improvements on a number of platforms, including DB2 and SQL.
- DB2 tools such as snapshots reports and views, db2pd and db2top.
- SQL Server tools, such as sys.dm * tools and knowledge on how to use. Query Analyzer, Reorg and statistics management.
- Windows Perf Monitor tools.
- Understanding and usage of workload advisors such as db2advis and SQL Server Tuning Advisor.
