Victor's Resume

VICTOR E. FLORES

***** ******* *****, ************, ** 78660 * H 512-***-**** * Cell 512-***-**** * *******@*********.***

DATABASE ADMINISTRATOR

Technically sophisticated Senior Database Administrator and Systems Analyst with more than eight years of experience leading the development, support, and maintenance of enterprise level database infrastructure and systems supporting mission critical governmental services. Comprehensive background in all aspects of Sybase ASE and MS SQL RDBMS technologies. Fully versed in modeling, design, business objects, and full lifecycle development. Expert creating backup/recovery and business continuity plans and processes. Respected project leader able to create innovative strategic level plans and direct multiple high-profile tasks. Senior initiator and persuasive advocate for leading edge infrastructure development. History of fast track promotion.

AREAS OF EXPERTISE:

* Full Lifecycle Project Management

* Systems & Data Security

* Relational Database Design & Modeling

* Backup / Recovery Strategies

* Deployments & Integrations

* QA Planning & Execution

* Strategic Planning

* Object-Oriented Technologies

TECHNICAL PROFICIENCIES

OS/Platforms: AIX 433/5.x; MS Windows 2000/2003 Server & Advanced Server & XP Pro

Database: Bradmark Norad Surveillance DB; CA Alfusion Erwin 3.52/4/41 Modeling; Embarcadero Analyst, DB Artisan 8.1, ER/Studio, Performance Center, & Rapid Studio, DB Artisan 8.1; MS Access 2003, DTS, Enterprise Manager, MDAC, Performance Counter, Query Analyzer, SQL Server 7/2000/2005, & SQL Profiler; Sybase ASA 5.5-9.0, ASE 11.5-12.52 (Windows/AIX), Database Examiner, DSEDIT, Infomaker 9.0, ODBC, Open Client, Powerdesigner Modeling Tool, & Sysmon

Utilities: Citrix MetaFrame, Partition Magic, McAfee Antivirus, Putty, WINZIP, WS-FTP

Backup: Tivoli Storage Manager 5.2, Tivoli Data Protector 5.21, SyncSort Backup Express 2.3

Applications: Best MIP Fund Accounting; Call Master Accounting; Cognos; GroupWise, MS Office Suite 97/2000/XP/2003, Project 2003, Visio Pro 2003, & Visual Studio. Panagon Filenet; PeopleSoft 8.3 & PeopleTools 8.3; Primavera Project Management

PROFESSIONAL EXPERIENCE

STELLARGY, LLC,Austin,TX (IBM contract position) 4/2007 to Present

Senior Database Administrator - Sybase ASE/MS SQL

Responsible for administering, developing, maintaining, and analyzing mission critical database systems composed of 20 SQL servers and 17 Sybase ASE

servers supporting 4 state agencies. Responsible for Ensuring maximum operability, stability, and security of the production database environment,

including scheduled events and applications, maintenance, administration of database integrity, synchronization, security, implementing database

changes and data loads, performance tuning and optimization, verifying daily backups of SQL Server 2000 and 2005 and Sybase 12.5 databases and transaction logs.

Possess strong skills in troubleshooting server applications in production, test and development environments. Strong knowledge in planning, installing,

configuring, managing, troubleshooting and Disaster Recovery of, SQL Server 2000 and 2005, SQL Server Reporting Services, and Sybase ASE 12.5.

Collaborate with strategic decision makers to develop requirements, specifications, and timelines for enhancements, upgrades, expansions, performance improvements,

and usability Consulting in a development, test and production environments. Evaluate opportunities for improvement and assess future needs.

Key Achievements:

? Deployed, developed, and administered databases in the testing, development, and production environments including proofs of concept and full operational systems. Upgraded and enhanced existing systems including service packs and patches.

? Monitored database performance health. Proactively created and administered capacity plans, schedules, and server clustering.

? Conducted ongoing performance tuning for indexes, compression, drive distribution, load balancing, and replication. Supported Data Transformation Services (DTS), with troubleshooting and performed job setup, execution and monitoring with SQL Scheduler.

? Performed critical periodic evaluation and maintenance for re-indexing, integrity checks, database shrinkage, log file monitoring, and disk space use.

? Installed, configured, and administered Sybase Adaptive Server Enterprise 11.5 through 12.5 RDMS software.

TEXAS DEPARTMENT OF TRANSPORTATION, Austin, TX 1997 to Present

Systems Analyst IV/Database Administrator - Sybase ASE/MS SQL, (2004 to 3/2007)

Administer, develop, maintain, and analyze mission critical database systems composed of 29 SQL servers and 21 Sybase ASE servers supporting over 10,000 users across 25 districts and 27 divisions. Ensure maximum operability, stability, and security of the production database environment, including scheduled events and applications. Collaborate with strategic decision makers in engineering, transportation, and executive roles to develop requirements, specifications, and timelines for enhancements, upgrades, expansions, performance improvements, and usability. Oversee the development, testing, QA, defect remediation, and implementation process in cooperation with key stakeholders. Evaluate opportunities for improvement and assess future needs.

Key Achievements:

* Served as the primary subject matter expert for infrastructure and technology operations for systems development including networks, applications, and user tools in addition to database systems.

* Evaluated business needs, existing systems capability, newly introduced technologies, and leading edge strategies to ensure application of state-of-the-industry best practices, infrastructure, and systems. Served as the driving force for initiating systems, infrastructure, and process enhancements.

* Developed schedules and maintained and monitored the strategic production extract-transform-load (ETL) processes across the enterprise ensuring maximum availability and optimal system performance.

* Designed, developed, and implemented an extensive suite of analysis, business reporting, and intelligence tools used for operational and strategic decisioning.

Systems Analyst III/Database Administrator - Sybase ASE/MS SQL, (2001 to 2004)

Analyzed systems, processes, and procedures with the goal of providing continual improvement of core technologies architecture and infrastructure. Led project teams through the full development lifecycle including planning, scheduling, testing, and implementation phases. Maintained ongoing contact with impacted stakeholders and served as the primary group contact for managing issues and concerns. Trained and mentored technical teams and user groups. Administered user/group access and permissions.

Key Achievements:

* Deployed, developed, and administered databases in the testing, development, and production environments including proofs of concept and full operational systems. Upgraded and enhanced existing systems including service packs and patches.

* Monitored database performance health. Proactively created and administered capacity plans, schedules, and server clustering.

* Conducted ongoing performance tuning for indexes, compression, drive distribution, load balancing, and replication. Supported Data Transformation Services with troubleshooting and performed job setup, execution and monitoring with SQL Scheduler.

* Performed critical periodic evaluation and maintenance for re-indexing, integrity checks, database shrinkage, log file monitoring, and disk space use.

* Authored the authoritative technical body of knowledge for DBA policies, procedures, schedules, and standard operating practices.

Systems Analyst II/Database Administrator - Sybase ASE/MS SQL, (1998 to 2001)

Served as primary resource for support, administration, maintenance, upgrade and development of Sybase ASE systems and processes. Administered up to 95 databases including physical storage, backup and recovery, performance monitoring, and tuning. Created and ensured compliance with standard operating practices and procedures. Partnered with development teams to analyze needs and develop new processes and tools. Developed, tested, and implemented new technologies.

Key Achievements:

* Modeled data needs and designed and built new database and objects.

* Installed, configured, and administered Sybase Adaptive Server Enterprise 11.5 through 12.5 RDMS software.

* Provided technical expertise for strategic evaluation, planning, and long-term development.

Systems Support Specialist IV, (1997 to 1998)

Managed LAN/WAN systems and connectivity, including inter-and intranet based systems for a 170 node network in a Novel 4.0/4.1 and Windows NT 3.51/4.0 environment. Ensured full information security for network and data systems. Installed, supported, upgraded, and enhanced hardware, software, and operating systems, including the coordination of divisional scheduling. Partnered with cross-functional groups of IT resources to design, develop, and maintain key infrastructure and systems. Trained staff in hardware support and administration in a mainframe environment.

Key Achievements:

* Supported software applications and tools, including Attachmate Extra, Netscape browsers, MS Office tools, Dbase III/IV, and McAfee Virus NT.

* Managed the implementation of SkillVantage Manager CBT.

* Created custom queries and reports per requirements by functional managers.

* Designed, developed, and implemented an Access 95 database to track and manage the division’s technical hardware inventory. Included a full suite of reporting features.

TEXAS DEPARTMENT OF CRIMINAL JUSTICE, Austin, TX 1996 to 1997

Systems Support Specialist III

Supported, administered, upgraded, enhanced, and installed new and existing hardware, workstations, software, operating systems, and networks. Aided with creating specifications and designing technology and infrastructure improvements. Served as development resource and inter-office coordinator for multi-department projects. Administered policies and procedures. Supported user groups across the enterprise.

Key Achievements:

* Created and conducted presentations and training programs for state agency personnel.

* Wrote technical policies, procedures, operations manuals, and troubleshooting guides.

* Evaluated new equipment and developed recommendations.

EDUCATION

Oracle Certification in progress

Master of Information Systems Management (Work In Progress)

KELLER GRADUATE SCHOOL OF MANAGEMENT AT DEVRY UNIVERSITY, Naperville, IL

Bachelor of Science Degree in Computer Information Systems

DEVRY UNIVERSITY, Irving, TX

Associate Degree in Business

WESTERN OKLAHOMA STATE COLLEGE, Altus, OK

Selected Professional Development

SQL Server 2005 Reporting Services (Modules 1 to 6) ~ Oracle Real Application Cluster Demonstration ~ Best of SQL Server 2005 ~ Mentoring for Employee Success ~ Novell Identity Management Solutions ~ OLPA Solutions ~ WSH & VB Script Programming ~ Sybase Monitoring Data Access in ASE Tables ~ MS Security Training ~Designing and Populating a Data Warehouse with SQL

Contact this candidate