We provide IT Staff Augmentation Services!

Database Administrator Resume Profile

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

Hire Now