OBJECTIVE

• A challenging position in a dynamic Technology organization with an opportunity for personal growth and professional advancement in Database Administration.

SUMMARY

• Professional with over 12 years of experience in Sybase Database Administration within a multi - server, multi-platform environment.
• Experience with Microsoft SQL Server 2005 Administration in a Windows 2003 Server environment.
• Excellent oral and written communication, presentation, and analytical skills.

TECHNICAL SKILLS

Hardware: Sun Solaris 8 &10, HP-UX 10.0 & 11, AIX 4.3,5.1

RDBMS: Sybase 15.7, 15.0, 12.5, Replication Server 12.6 & 15.6, MSSQL Sever 2005

Tools: DBArtisan, Sybase Central, SQL Advantage, MS Project, ClearCase, Eclipse

Platforms: Unix, Linux, Windows XP/7

Languages: T-SQL, SQL, Kornshell, Java

PROFESSIONAL EXPERIENCE

Confidential, McLean, VA

Sybase Database Administrator

Responsibilities:

• Analyze and remediate security vulnerabilities in Java code
• Participate in Java code reviews
• Deploy database schema changes to development environment
• Perform database builds for testing java applications in development environment
• Support daily development activities and requests for DB2 and Sybase databases
• Support daily UAT activities and requests for database refreshes of DB2 and Sybase
• Perform cross-platform database refreshes from Solaris to Linux

Confidential, Crofton, MD

Sybase Database Administrator

Responsibilities:

• Monitor production environment performance on a daily basis
• Deploy database schema changes to production
• Monitor and maintain database backups for recovery
• Review, approve or reject data analysis SQL scripts for execution in production
• Analyze database statistics using optdiag to assess database fragmentation
• Perform regular database table and index maintenance for query performance improvements
• Review/test stored procedures for performance optimization
• Perform database loads to development environment from production to support development and testing efforts. deployments.
• Install and configure EA Servers, and SUNWebservers
• Support daily production activities and requests
• Performance and Tuning Analysis
• Evaluate work processes and identify areas for improvement
• Monitor and troubleshoot Database Replication System
• Perform technical reviews
• Perform Work Product Reviews of technical documents
• Track weekly application outages to measure success rate of SLA
• Periodically review security requirements for deployment of new application enhancements.

Confidential, Herndon, VA

Sybase Database Administrator & MS SQL Server 2005 Administrator

Responsibilities:

• Set up maintenance plans for full database backups, transaction log dumps, and update statistics.
• Set up cleanup tasks for old backup files to manage space.
• Perform database restores from production to test and development environments.
• Shrink database logs
• Monitor database and backup space on SAN attached storage (PILLAR).
• Check daily backups for errors and resolve them.
• Analyze SQL performance issue using sql traces and Database Tunining Advisor.
• Perform data imports and exports using SSIS packages.
• Install MS SQL Servers.
• Provide support for approximately 160 customer databases ranging in size from 500 MB to over 350 GB in the development, test, and production environments.
• Perform and manage database backups to ensure recoverability.
• Execute dbcc checkstorage on a weekly basis and review results to analyze any hardfaults and to apply fixes based on the errors reported.
• Execute update statistics for database tables to tune and improve performance.
• Create and update UNIX shell scripts to solve business challenges.
• Implement new UNIX shell scripts in cron.
• Create new tables, triggers, stored procedures and views.
• Setup MSA replication.
• Monitor repserver system to determine if any latency or any repserver issues exist and respond accordingly.
• Resolve replication errors that cause DSI threads to go down, such as duplicate key entries, database object permissions errors.
• Provide 24/7 on-call support in addition to regularly scheduled weekend database upgrades.
• Apply EBF patches to ASEs as required.
• Perform Ad-hoc queries as requested by internal and external customers.
• Monitor ASE error logs on a daily basis.
• Create and configure databases for new Confidential customers.
• Troubleshoot database access errors
• Perform database upgrades for the Confidential Web Presentment system.
• Monitor database growth and maintain data and index space at appropriate levels.
• Perform data modification tasks as requested by external and internal clients.
• Perform data extractions.
• Perform data and index reorgs to reclaim space.

Confidential, Rockville, MD

Sybase Database Administrator

Responsibilities:

• Performed lead IT role in interfacing with the Human Resources Department of the US NRC, to provide IT planning and maintenance for Payroll, and Time and Labor projects.
• Performed analysis of production systems and provided input into systems design and process re-engineering initiatives based on existing and proposed process flow.
• Responded to our end-user requests in a timely manner to assure sound customer service practices were maintained.
• Maintained database pre-production and production environments for PeopleSoft 6.x, 7.5 HRMS for Time & Labor, and Payroll support.
• Collaborated with key USNRC personnel to planned and implement Sybase Replication system for failover.
• Monitored HRMS production system for performance and disaster recovery.
• Performed database failover/failback procedures to the secondary and primary databases to ensure business continuity.
• Performed Sybase dataserver upgrades.
• Rebuild of Sybase Adaptive Servers and Replication Servers.
• Created and/or modified UNIX shell scripts for monitoring HRMS production systems.
• Created stored procedures as needed.
• Planned and performed database migrations project to new Sun Solaris hardware.
• Updated HRMS Database Maintenance manual, and Replication manuals periodically to assure proper maintenance practices were adhered to.
• Troubleshoot Errors for HRMS batch jobs scheduled using Tivoli Workload Scheduler.

Confidential, Reston, VA

Sybase Database Administrator

Responsibilities:

• Build Sybase Adaptive Servers on Sun Solaris 2.x and HP-UX platforms.
• Build Sybase Replication Servers.
• Build Sybase Monitor Servers.
• Maintained Installation standards for all Sybase products.
• Maintained infrastructure for development, production, and QA environments.
• Maintained patch requirements for approximately 200 dataservers.
• Developed SQL stored procedures for monitoring database thresholds.
• Designed small scale databases.
• Migrated SQL code and schema from development to QA.
• Provided dataserver performance tracking.
• Provided dataserver tuning for production environment.
• Reviewed Third-party software for use by DBA team.
• Analyzed and tracked Sybase stack traces for production servers.
• Created on-line form and email notification script to automate creation of user database logins for 24/7 on-call rotation support.

Confidential, Reston, VA

Quality Assurance Engineer

Responsibilities:

• Identified and documented business processes for use in implementing software change requests.
• Developed and updated test plans, procedures, and test strategies.
• Performed functional, stress, and acceptance testing in Client/Server environment.
• Created and ran automated test scripts and suites using test tool, QA Partner.
• Performed manual tests, and reported test results and problems to management.
• Tested internal AOL client applications.
• Supervised 8 QA Engineers as QA Lead.
• Implemented orientation training course for new employees.