Professional Experience 15 years

Confidential

Sr. Database Administrator/Application Support

• Oracle to SQL Server Replication including large data management and structural synchronization
• General maintenance and disaster recovery
• User access and security particularly as it relates to PHI and HIPPA
• Automation of environment monitoring to ensure structural integrity pre and post deployment cycles
• Performance monitoring, trending, tuning, and environment recommendations
• Maintenance automation to ensure robust and consistent database and server integrity
• Mentoring and training for Jr. level DBAs
• ETL development, tuning, and troubleshooting
• OLTP/ OLAP production support
• Log Shipping automation and troubleshooting for disaster recovery purposes
• Capacity planning and Installation of new SQL Server environments cluster and standalone
• 24x7 On Call Support
• Additional Senior and Lead DBA Tasks:
• Proactively lead in problem resolutions between client services, QA, Development and Production Support teams
• Identify any underlying process opportunities and facilitate long term solutions
• Ensure 27x7 uptime for all databases
• Eliminate bottlenecks within the application architecture where applicable
• Risk mitigation and root causal analysis
• Process documentation for training and historical purposes
• Software acquisition review and recommendations
• Key Achievements:
• Real time replication streamlining for large data sets between Oracle and SQL Server. This eliminated many data syncing issues and time constraints which placed the company in a much better position for interoperability efforts

Confidential

Sr. Database Administrator/Application Support

• General maintenance, user access, and security
• Performance troubleshooting and tuning
• System level development of automation maintenance tasks
• Mentoring and Training for Jr. Level DBAs
• Support as it relates to OLTP
• Installation and Maintenance of SQL Server Failover Cluster using Microsoft Cluster Server
• DR/Log Shipping automation and troubleshooting
• Alternating 24x7 On Call Support
• Additional Senior and Lead DBA Tasks
• Risk mitigation and root causal analysis
• Process documentation for training and historical purposes
• Software acquisition review and recommendations
• Best Practices benchmarking
• Weekly team status reports and review
• Key Achievements:
• Success with SQL Server to Oracle migrations

Confidential

Sr. Database Administrator/Application Support

• General maintenance and disaster recovery
• User access and security
• Performance monitoring and tuning
• Database migration and testing
• DBA Technical Writing and Documentation, Mentoring and Training for Jr. Level DBAs
• Support as it relates to OLTP and OLAP
• Replication and distributed database implementation and support
• Maintenance automation utilizing third party tools such as OPALIS, Redgate, and Embarcadero Job Scheduler
• Installation and Maintenance of SQL Server Failover Cluster using Microsoft Cluster Server
• Alternating 24x7 On Call Support
• Additional Senior and Lead DBA Tasks
• Process documentation for training and historical purposes
• Backup for Jr. DBA on call scenarios
• Weekly team status reports and review
• Meeting agenda and facilitation
• Key Achievements:
• Provided fully documented DBA process and procedures where minimal documentation existed before
• Supported 4000 SQL Servers Internationally

Confidential

Database Administrator/Application Support

• General maintenance and disaster recovery
• User access and security
• Performance monitoring and tuning
• Design modification and optimization
• Database migration and testing
• Data Dictionary
• Development and support as it relates to OLTP
• Replication and distributed database implementation
• Key Achievements:
• Provided optimal database development, support and security as it relates to OLTP for the CDC
• Developed and implemented data desensitizing strategies in order to synchronize Database Environments

Confidential

Database Analyst/ Production Support/Reporting

• Cross platform integration SQL-Server, ORACLE, Access for enhanced transaction research and production support
• Responsible for the validation of invoicing and transaction data for multimillion dollar clientele
• Process streamlining as it related to the automation of manual validation processes
• Provided full ADHOC and scheduled reporting
• ETL utilizing SSIS to provide integration of ASCII data into reporting analytics
• Key Achievements:
• Enhanced validation processes to be faster, more comprehensive, and more accurate

Confidential

Database Administrator/ HRIS Professional/Business Analyst

• Cross platform integration SQL Server, DB2, Access for enhanced reporting out of PeopleSoft
• Responsible for automated nightly ETL's related to OLAP applications
• Full Differential backups
• ETL utilizing DTS to provide integration of ASCII data into reporting analytics
• Data Modeling
• Provided ADHOC and scheduled reporting
• Trending and statistical analysis as it related to employee review and merits across organizational functions
• Utilization of Access, SQL Server, Visual Basic and DB2 to provide user friendly OLTP applications
• Key Achievements:
• Turn around time of HRIS reporting was reduced from several days to less than a day

Confidential

Database Administrator/ Inventory Specialist

• Database functionality evaluation and upgrades.
• File Maker Pro Database design for inventory tracking, reporting and cost analysis.
• Provided inventory support in a call center environment for various clients.
• Intake and tracking of all hardware and software for multiple clients and technicians.
• Key Achievements:
• Jointly responsible for the implementation of a technical support tracking system

Confidential

• Technical Manager and Pre-Press Database Administration
• Unix/Solaris and Access based repository and database management:
• Ran T-SQL scripts daily to provide detailed database information for multi-million dollar clients.
• Access database integration used to create kit labels for customer specific bundles
• Updates to customer databases via FTP or DLT Tapes.
• Nightly tape backups
• WORM Drive Optical Storage of client files
• PC/Printer troubleshooting:
• Provided technical support for approximately 50 users in a MAC/PC/UNIX cross platform environment
• Project Management:
• Out of State travel to obtain requirements definitions
• Enterprise Architecture Evaluation
• Material acquisition and expensing
• Process testing
• Training
• Implementation
• Other Miscellaneous Tasks:
• Y2K resolves and issue tracking
• Utilized Microsoft Great Plains to retrieve and share client documents for print production
• Pre-Press document manipulation including text and graphic design
• Key Achievements:
• Provided benchmark media duplication for large projects utilizing Network Administration Platform integration.
• Provided benchmark project implementations and technical support for clients abroad including Yokogowa Tokyo

Confidential

Computer Technician/Class Instructor

• PC/Printer repair troubleshooting:
• PC Refurbishment, General Technical Support, A class instruction for non-employable homeless individuals