We provide IT Staff Augmentation Services!

Sr. Sql Server Database Administrator Resume

Las Vegas, NevadA

SUMMARY:

  • A highly motivated, deadline driven, customer service focused, database evangelist.
  • With broad range of technical and professional expertise in complex solution design and delivery. Skilled at participating and leading several concurrent, top priority, multidisciplinary projects.
  • Accomplished in project delivery with several development methodologies.
  • Proven Successful delivery of projects that break elaborate multifaceted problems into small manageable customer value centric solutions.
  • A demonstrated Ability to analyse, reorganize and translate corporate procedures into IT Solutions.
  • A proven self - motivated, self-starter that proactively delivers enterprise level solutions, with a minimum of supervision.
  • Generally, as a DBA my main role is to maintain database availability by identifying and solving database problems.
  • Coordinating growth, changes and patching to databases; and by supporting users and the business. I enjoy the challenge of the pursuit of knowledge while balancing a hectic workload with time to continue to strengthen my skill set and grow within my career.

TECHNICAL SKILLS:

Proficient in: Sql Server 6.5, 7.0,2000, 2005, 2008, r2,2012,2014, 2016, 2017, 2019 Azzure Oracle 6.x, 7.x,8.x,8i,9i,10g,11g

Familiar with: DB2, PICK, MySQL, Postgress 7.1,7.2,7.3,7.4

OS: Windows, HP-UX

Windows: PowerShell, VBScript

Unix/Linux BASH, C: Shell

Database Design Tools: Embarcadero ER Studio, Data Architect, ERWin, Oracle CASE

Development Languages: Transact SQL, PL/SQL, SQL, pgPLsql, OCX, ASP, ASP. Net, JSP, PHP, Perl, ColdFusion, Visual Basic 4,5,6,net (VB), VBA, Visual C++, C#, COM objects OCX, ASP, ASP.net, JSP, PHP, Perl, Oracle Developer Suite 2000, 6i,9i, Forms 2.3,3.0,4,4.5,5x,2000,6i,9i

Utilities and Tools: Spotlight, FogLight, Litespeed, Sql Optimizer, TOAD, Red Gate, sql tool belt. Idera Diagnostics Manager including Newsfeed and Mobile components.

ESX VMWARE Tools: Suite of VM server Management

Formal Methodologies: Agile, SCRUM, Object oriented, CASE*Method, RAD, JAD, Systems Development Life Cycle, Kimball, NHibernate Frame Work, Entity Framework Frame Work

End User Tools: Oracle Discover, Sql Server Management Studio, Sql Server Reporting Services SSRS, Sql Server Integration Services SSIS, SQL Navigator, Procedure Builder, Telnet, FTP, Secure Shell, VPN Microsoft Office Products, Word, Excel, Access, Publisher, FrontPage, Visio, One Note MS Project, Visual Interdev, Lotus notes, Coffee Cup, Dreamweaver, Studio MX, SQLYog, Navcat, Webmin Pg. Admin III, Actuate, CVS, RCVS, PDA Tool Box

Database Administration Tools: Red Gate SQL Tool Belt, SqlBackup Pro, Sql Source Control, SolarWinds DPA ( database performance analyzer)

Spotlight, Foglight, RMAN: backup and recovery, Idera SqlDiagnostics Manager, Idera SqlSafe, Idera Defrag ManagerDeveloped tools for database administration sizing, tuning, cloning, moving, backup and recovery

PROFESSIONAL EXPERIENCE:

Confidential, Las Vegas, Nevada

Sr. Sql Server Database Administrator

Responsibilities:

  • Managed hands-on the 24x7 database operational responsibilities. 24x7 On Call support. Managed Backups, restores, tuning, patching and upgrading.
  • Ran Delivery Team Meetings and briefings
  • Created Policies and procedures for Lifecycle management
  • Powershell Script Creation, For Object Deployments, Size Reporting, Backup Reporting, Error Log Reviews, and Development environment Refreshes.
  • Created Deployment and a change management procedures and policies
  • Trained staff in Polies and procedures
  • Planned and carried out hardware, software and server configuration changes to ensure the best performance for our systems
  • Analyzed systems and developed better and faster approaches to database software development
  • Carried out several Tuning exercises for Server operation and T-SQL Code enhancements
  • Developed Database Growth projections based upon past performance and growth information
  • Planed and managed database growth to ensure san was operating and peak efficacy
  • Coordinated production deployments, using CVS, Tortoise, Redgate, and Microsoft TFS Change Management software.
  • Created several white papers for brown bag lunch and learns with the development staff to coach higher coding standards and to develop a consultative relationship with development staff across several business units
  • Analyzed and selected database monitoring and performance analysis tool
  • Standardized database maintenance tasks across all servers.
  • Was liaison for the SQL server Database Audits for both internal and external auditors. Provided research and documentation as requested for our Commercial and Government Clients.
  • Monitored and corrected performance issues worked with Development staff to tune and review sql queries for better more efficient and fast performance.
  • Created SQL Server Standards for Development Staff peer Review of SQL Development Code.
  • Worked on Trouble shooting access control issues with external and internal systems and resources
  • Moved our Las Vegas based datacenter to our Texas based service provider.
  • Utilized SVN source Control, Service Now ticketing systems, IDM - access control and co-ordination
  • Database Environments: SQL Server 2005, 2008, 2008r2, 2012, 2014, 2016, 2017, 2019, AZURE Clustering, Replication Always on and Cloud based database systems

Confidential, Carlsbad, CA and Las Vegas, NV

Sr. Sql Server Database Administrator

Responsibilities:

  • Managed hands-on the 24x7 database operational responsibilities. Backups, tuning, patching and upgrading. Made hardware and server configuration changes to ensure the best performance for our systems.
  • Moved the companies Datacenter from Carlsbad California to Las Vegas Nevada. I had Complete responsibility for all things related to a database, almost every application was involved. I did the planning, testing, protyping as well as carried out the work.
  • Developed and Application repository to document the databases involved with which applications and servers. As well as which users and infrastructure people were involved. Created several cross-application integration’s with SSIS
  • Created a dev set of servers and automated regular refreshes. Worked with canned application vendors to improve their products as far as their involvement with our databases. Such as making recommendations as to more efficient methods performing their tasks.
  • Worked with development staff to create a metadata dictionary and a glossary of terms
  • Tuned Queries and reports for Great Plains systems
  • Monitored and corrected performance issues
  • Created and managed several Clustered environments for high availability, sql servers 2012 always on, and transactional replication. Created and managed log shipping for some of our smaller and slower needs environments.
  • PowerShell Script Creation, Size Reporting, Backup Reporting, Error Log Reviews, and impact analysis
  • Produced set of basic SQL standards for our developers and everyone to adopt
  • Implemented centralized DBA management server, worked with SolarWinds, Ignite monitoring systems
  • Worked with Footprint ticketing system
  • Database systems used: SqlServer 2008,R2, 2012 SSRS, SSIS, Clustering, Replication Always On

Confidential, Dallas, TX

Sr. Sql Server Database Administrator

Responsibilities:

  • Provided 24 x7 Database support, managed Production support including Backups, Performance, Disaster Recovery, High Availability Clustering, Replication, Log Shipping, Patching and Upgrading. Supported Development Staff with builds, refreshes, roll outs, tuning and development. Architected, engineered and delivered database systems for all enterprise operations.
  • Created an inventory of servers, databases, and applications. Pulled data out of SCOM system for population and maintenance.
  • Managed the release process from a sql server database perspective
  • Tuned Queries and reports for Great Plains systems
  • Created project plans to upgrade production systems to Sql-server 2012 from 2000 and worked the plan to perform the process
  • Created and managed several Clustered environments for high availability. Created and managed log shipping for several environments.
  • Developed and introduced a set of basic SQL standards for
  • Implemented centralized DBA management server
  • Worked with Remedy ticketing system
  • Database systems used: SqlServer 2000, 2005, 2008,R2, 2012 SSRS, SSIS, QuickBase

Confidential, Dallas, TX

Sr. Sql Server and Oracle Database Administrator

Responsibilities:

  • Manage all Aspects of a 24 x7 online Enterprise Web based E-Commerce Database, including Production support including Backups, Performance, Disaster Recovery, High Availability Clustering, Replication, Log Shipping, Patching and Upgrading. Supported Development Staff with builds, refreshes, tuning and development. Architected, engineered and delivered database systems for ecommerce and product sales.
  • Created an inventory of servers, databases and helped with the Microsoft True Up process for all Microsoft products.
  • Managed the release process from a database perspective
  • Created several reports the indicated order flow and Customer flow issues
  • Created project plan to upgrade production systems to Sql-server 2012 from 2000 and worked the plan to perform the process
  • Created several Clustered environments for high availability. Created and managed log shipping for several environment’s.
  • PowerShell Script Creation, Size Reporting, Backup Reporting, Error Log Reviews, and Development environment Refreshes as well .as object usage impact analysis
  • Developed and implemented basic SQL standards for the development staff to follow
  • Implemented Quest Litespeed Backups across enterprise, Quest Diagnostics, Foglight and Spotlight. Worked with Idera Diagnostics Manager including Mobile and newsfeed components for monitoring and alerting. Setup up Idera SqlSafe, and Idera Defrag Manager, Developed polices for each of these tools to automate many daily tasks processes. Created and developed custom reports that report server health for us during Month End activities.
  • Was Secondary Oracle DBA
  • ESX VMWARE Tools Suite of VM server Management
  • Database systems used: SqlServer 2000, 2005, 2008,2012 SSRS, SSIS Oracle, 10g

Confidential, Houston, TX

Sr. Sql Server and Oracle Database Administrator

Responsibilities:

  • Decommissioned and Consolidated databases. Managed and completed Change Requests.
  • Performed day to day DBA activities as required to keep databases running, this includes backup, recovery, Tuning and monitoring,
  • Provided 24-7 on call support. Coordinate upgrades, patching and refreshes with team leaders to ensure smooth and seamless transitions from Dev, test, staging and through to production.
  • Lead and Designed and Developed SqlServer monitoring and alerting system and developed technical documentation so that the procedures were able to be rolled out to the systems that are managed by a third-party group.
  • Architected and developed systems to monitor backup successes. Including stored procedures and functions in both Oracle and SQL Server
  • Managed and Resolved server issues and reporting findings back to 3rd party support group to undertake the work required.
  • Cloned and refreshed databases to sync and clone production environments with dev and testing in both Oracle and SqlServer
  • Utilized SSIS to extract data from Oracle and load in sql server and spreadsheets.
  • Database Restores, cloning and refreshes as required. Installation and configurations of database servers and database software
  • ESX VMWARE Tools Suite of VM server Management
  • SqlServer 2000, 2005, 2008, Oracle 8i, 9i, 10g, RMAN, Toad

Confidential, Houston, TX

Sr. Sql Server and Oracle Database Administrator

Responsibilities:

  • Developed SQL server Alerting and Deadlock Watching System
  • Performed day to day DBA activities as required to keep databases up and this includes backup, running recovery, Tuning and monitoring. Provided rotational on-call support
  • Developed Sql server performance benchmark system including technical documentations and procedures required for roll out to other systems worldwide.
  • Auditing and compliance focal point for the DBA team. Developed and created processes and procedures for the group to follow
  • Performed refreshes to databases to sync and clone production environments with dev and test in both Oracle and SqlServer
  • Designed and developed systems to monitor backup successes. Including stored procedures and functions in both Oracle and SQL Server
  • Loaded data into sql server using SSIS from spreadsheets, emails, text files and xml file sources
  • Lead DBA teams to perform required programming and auditing
  • ESX VMWARE Tools Suite of VM server Management

Database systems used: SqlServer 2008, R2, SSRS, SSIS, Oracle 9i, 10g, 11g and RAC, Toad, DBArtisan

Confidential, Houston, TX

Sr. SQL Server Database Administrator/Architect

Responsibilities:

  • Designed and created the architecture of a cell phone bill processing system including user security as well an encrypted data such as credit card numbers. Documented new processes and technical documentation and specifications for designs.
  • Created and gathered requirements and created both logical and physical data models to support the requirements of the system. Architected a High performance and high Availability clustered system to accommodate projected workloads. Originally the system could not even handle 5 users and we had 750 without issue.
  • Developed and tested server side / back end a stored procedure required to allow .Net front end components to utilize the back-end databases objects and functionality. Ensured Maximum server uptime
  • Migrated data from older database designed to new architecture and developed sever reports using SSIS and SSRS
  • Managed database object development with developers. Installation and configurations of database servers and database software. Locally and on remote hosted servers. Develop scripts and models templates so objects are created uniformly.
  • Developed stored procedures, function used for development frameworks including NHibernate Frame Work and Entity Framework Frame Work.
  • Database systems used: Sql server 2008, R2, SSRS, SSIS, Red Gate, ER Studio, Data Architect, clustering

Confidential, Houston, TX

Sr. SQL Server Database Administrator/Architect

Responsibilities:

  • Managed and controlled all corporate wide database activities, created SLA’s, created database development standards, Created SSIS interfaces between Oracle and Sql-Server, Created several SSRS reports,
  • Managed ongoing database disaster recovery efforts, as well daily backups, restores, log shipping, mirroring and replication. Installation and configurations of database servers and database software. Tested and implemented High availability clustering.
  • Managed systems development project for inventory control. Also managed the bar-coding and gathering of the physical inventory from across the company. Performed short- and long-term sizing and growth projections.
  • PowerShell Script Creation, Size Reporting, Backup Reporting, Error Log Reviews, and Development environment Refreshes as well .as object usage impact analysis
  • Upgraded and Migrated systems from one version to another, integrated data across systems, created a common data, databases, that included what data we stored about our people, our customers.
  • Created stored procedures and functions as required to support the development effort. Also worked with developers to test and tune their code. Created a set of standards that I implemented across the enterprise for best practices if database development.
  • Utilized SSIS to extract data from a web base API to load up to date currency conversions rates to be available in our financial system.
  • Lead teams of developers and inventory crew to perform across the company inventory.
  • Managed the upgrade of JD Edwards financials ERP system from a DBA role this included several cut over test and creating several development, testing and staging environments.
  • Reverse engineered databases to develop data models that were used for updates, impact analysis, system documentation and to develop training materials for the development staff.
  • Chaired Central change control committee. Spearheaded Server-Database Consolidation
  • ESX VMWARE Tools Suite of VM server Management

Database systems used: Sql server 2000, 2005, 2008, R2, SSRS, SSIS, Red Gate, ER Studio, Spotlight, Oracle 9i, 10g

Confidential, Houston, TX

Principle Consultant

Responsibilities:

  • Developed SQL server database replication application modifications to stored procedures and functions as well as VB code and several batch scripts to transmit data over satellite links to 160 offshore Drilling platforms for Transocean. Designed and developed a proof of concept, procedures and methods to be able to extract data from their legacy system into a new architected rig management application. Migrated application from .
  • PowerShell Script Creation, Size Reporting, Backup Reporting, Error Log Reviews, and Development environment Refreshes as well .as object usage impact analysis
  • Created a proof of concept to win project to port data from there Oracle system to their SQL server rig management system. Using SSIS to extract translate and load data from there old system into their new system and create reports to ensure complete and full data loading.
  • Cloned and refreshed test environments for production to give development staff actual data and system loads to test and develop their system changes. This included creating a test drilling plate form and test home office environments for impact analysis.

Database systems used: Sql server 2000, 2005, SSIS, Oracle 9i

Confidential, Houston, TX

Principle Consultant

Responsibilities:

  • Provided design, analysis and developmental support for mortgage Loan administration.
  • This includes option ARM loans and Loan boarding Oracle PL/SQL(Packages, procedures, functions and triggers), SQL*Loader. Import and export data to and from non-Oracle sources.
  • Shell Scripting for performing complex processes for daily operations and reporting
  • Worked on application migration from 9i to 10G, Provided month end support.

Database systems used: Oracle 9I, 10G, PL/Sql, Script Development, Gateway, Sql server 2000

Hire Now