We provide IT Staff Augmentation Services!

Senior Sql Server Dba Resume

2.00/5 (Submit Your Rating)

Scottsdale, AZ

TECHNICAL SKILLS:

Platform: VMWare ESX, Hyperion, Dashboard, Spot - Light, Fog-Light Windows Server 2000, Windows Server 2008, Windows Server 2012, and Windows Server 2016, LUNIX, UNIX, Ubuntu, RedHat, and Centos

Application: Java, Java Script, OOP, C++, Jscript, .NET, PHP API, ERP, SDLC, REACT, Agile, and SCOM

Cloud Base: AWS, AWRDS, Windows Azure, SQL Azure, Box, and SAAS

DB OS: SQL 2000, SQL 2008R2, SQL 2012, SQL 2016, Big Data, Open Base, Oracle10g, Hive, MariaDB, and MySQL

Development: SQL BI Stack, Stored Procedure, Views, ETL Processing, Crystal Reporting, ERP, T-SQL, PowerShell, Shell Scripts, P-SQL, MicroStrategy, PG Admin III, and PostgreSQL:

DB Reporting: SSRS, Crystal Reporting, HTML, XML, Tableau, and Clarity

PROFESSIONAL EXPERIENCE:

Confidential

Senior SQL Server DBA, Scottsdale, AZ

Responsibilities:

  • Knowledge within (SQL) environment with planning, analysis, report design interfaces, and implementation for application owners.
  • Developed and enforced database administration user standards and procedures; audits, modifies, and amend s data in systems using SQL commands.
  • Setup Mongo Database application, maintain user support for the MongoDB.
  • In-depth knowledge and experience with database replication between multiple SQL Servers and remote sites
  • Worked with programmers/analysts and /or data architects to review logical and physical data models. Ensuring that our databases meet overall business information needs and new requirements.
  • Wrote SQL queries to perform ETL processes that retrieve from relational source systems.
  • Conferred with programmers/analysts, and customer to define functional requirements, perform data modeling and implement final products; resolved errors and interface problems that ensured system integrations in accordance with development standards.
  • Used PowerShell and/or shell Script to develop, plan, and validate data for new or modified databases. refine system documentation applying quality assurance and security standards to minimize loss of data, in an interruption of service or in the event of equipment failure.
  • Performance tuned SQL Server using Iindex tuning, profiler, PerfMon, DTA, DMVs and DMFs.
  • Constructed, and maintained databases associated with various applications, and development projects based on the logical data model and physical database designs.
  • Performance tuning ACT custom application for VCE using facts from performance counters. Install new SQL Server instances on new VMware servers as needed. Some were 2012, clustered, Reporting Services farms or distributed reporting services, and some were standard installs. Advised management on best practices for new clustered database environment. Performance tuned SQL instances, for temp database per CPU Performance tuned SQL queries, and stored procedures while mentoring developers to test slow running queries and how best to improve slowest running queries etc. Query running 3 mins now will run instantly because of maintenance to statistics, and indexes
  • Assessed and incorporated user story analysis and elaboration to optimize software solutions.
  • Worked on Agile development, Agile methodologies, SQL DBMS, HTML, Java, JavaScript, Linux scripting, object oriented programming, Oracle, Oracle databases, PL/SQL, relational databases, SQL, SQL Developer, UNIX, and XML.
  • Prepared project work time, and cost estimates for manager’s review, and approval, and oversaw work activities assigned to junior DBA staff.

SQL Server DBA

Confidential, Scottsdale, AZ

Responsibilities:

  • Created, developed, and maintained solutions using SSIS, specifically ETL operations within an Enterprise Level environment
  • Managed the data integrity, security, availability, performance; facilitatinge necessary changes to improve overall system health.
  • Installed and configured SQL Server 2012 and SQL Server 2016 with High Availability / AlwaysON, Contained databases, or Column Store indexes by client requests.
  • Granted users in database security roles, and Created domain groups to put users into… also added users domain groups in Active Directory.
  • Queried and analyzed large sets of data to draw conclusions and make recommendations to the business using statistical models and data mining techniques combined with business and operational knowledge.
  • Conducted various analyses and providing thought leadership to identify new ideas that lead to improved efficiency and customer experience in our Inbound Contact Center.
  • Supported the business with process mapping, identification of process improvements opportunities for the purposes of generating cost-savings and improving customer satisfaction.
  • Worked closely with Operations leaders, and Project Managers to further develop existing ideas, prioritize them, and implement them.
  • Developed cost-benefit analyses and prepare business presentations to share with leadership and gain buy-ins.
  • Reengineered SQL and Windows systems, and code for continuous improvement of slow running servers and queries.
  • Assessed and incorporated user story analysis and elaboration to optimize software solutions.
  • Worked on Agile development, Agile methodologies, SQL DBMS, HTML, Java, JavaScript, Linux scripting, object oriented programming, Oracle, Oracle databases, PL/SQL, relational databases, SQL, SQL Developer, UNIX, and XML. Built new servers according to standard template with PowerShell script Managed memory and performance for SQL Server , SSRS, SSIS, SSAS based off business performance needs Collected performance data using standard tools such as PerfMon, SQL Diag and SQL Profiler. Backup, and restore databases, performance tuning, code promotion, grant user access.
  • Participated in team meetings to plan for future scalable growth business needs from developers and vendors.

Confidential, Phoenix, AZ

SQL Server Support SQL 2008R2, SQL 2012SP1

Responsibilities:

  • Client Services, Platform, and Services Layer support for Azure, and Software Support of V-Cloud, and VMWare, Jira Tracking,
  • Provided ideas for conceptual logical design for existing or new table changes for new databases/Instances.
  • Built new virtual machines using VMware to test out new purposed code changes with application, business analysis, and sql developers.
  • Worked with a team of programmers writing a custom billing program. The billing program makes SQL Q ueries from Oracle data through the ODBC driver to be imported into SQL Databases and Reporting.
  • Worked with System Administrator to update, add or change Application ID for groups supported by DBA team.
  • Setup of Peer to Peer Replication to provide synchronous changes to secondary datacenters by the primary datacenter databases and by doing this it was a provided way of a D&R Strategy in case the primary data center goes down the secondary would provide primary support.
  • Enhanced overnight migration support for Oracle 10g to SQL 2012 by using Attunity drivers instead of ODBC drivers for Migrating Oracle 10i to SQL Server 2012. Production support went from 7 hours overnight to 2 hours overnight.
  • Enhanced automation for reoccurring and redundant tasks i.e. backups, performance monitoring, and reporting for managers.
  • Worked with various approved (IT)vendors, and software developers, and application developers with new promoted code changes for reports directed by management.
  • Supported ((4) SQL Productions Servers, (3) SQL Development Servers, (2) SQL Staging Servers, and a (1) SQL Report Server instances.
  • Collected performance data using standard tools such as PerfMon, SQL Diag, and SQL Profiler.
  • Server upscaling, and migration from version 2008 to SQL Server 2012 and 2014
  • Worked independently with agile environment to ensure proper code elevation and code standards were communicated and followed.
  • Freedom Financial Network group 10 SQL Server instances & 86 databases in all versions from SQL Server 2008 - 2016. Engaged in a project to implement Ellucian Colleague. In the process of converting several in house applications\DB systems to the new ERP system.
  • Reengineered SQL and Windows systems, and code for continuous improvement of slow running servers and queries.
  • Assessed and incorporated user analysis and guidelines to optimize software solutions and overnight processes.
  • Assessed and incorporated user story analysis and elaboration to optimize software solutions.

Confidential, Minneapolis, MN

SQL Server Support & Server Migration Support

Responsibilities:

  • Identified, and resolved issues and perform maintenance as needed.
  • Ensure Oracle and Microsoft SQL Server databases are operational 24x7 in multiple SaaS environments within the Enclave Military Systems (DOD).
  • Built Enterprise Servers using Shell Scripting/PowerShell Scripting to support 24x7
  • Followed and improved documentation from other Application Owners and Business Intelligence
  • Adapted in a dynamic environment, working from varied company and remote locations.
  • Identified and resolved issues and perform maintenance as needed.
  • Demonstrated great analytic skill, able to independently troubleshoot application issues with vendors’ technical support.
  • Received and addressed automated pages from proactive DBMS and database monitors.
  • Worked independently and on a team in an agile environment.
  • Received and addressed automated pages from proactive DBMS and database Fog light/SCOM monitors.
  • Troubleshot Jira tickets with database issues using Software as Agile Support
  • Managed data integrity, security, availability, recoverability, performance, and facilitated changes to improve.
  • Designed and created a control database. Automated reports. Investigated and inventoried existing reports to write project estimate for customer

Confidential, Fort Lauderdale, FL

SQL Server Support & Server Migration Support SQL 2008R2, 2012SP1

Responsibilities:

  • Assessment of SQL Environment for new installation consolidation which save the company thousands on licensing and uptime, configured cluster for active/active build (4) node setup, storage configuration for quorum drives, CPU, Memory, IO and security
  • Assessment of Batch Processes, ETL, SSIS, Database design for Optimization & Performance improvement
  • Built and Supported innovative workflow engines with user interfaces in the EMR world.
  • Supported Soarian Clinicals users with application interface for clinical reporting
  • Managed change windows for database environment related changes (i.e. DBMS software or instance/database configuration).
  • Configured DBMS software (i.e. database servers, database connectivity servers) on database servers.
  • Identified application databases that will be impacted by DBMS software upgrades
  • Executed DBMS software upgrades
  • Monitored database capacity so that it does not adversely affect SQL VMWare Servers performance.
  • Performed ongoing OS configuration changes for DBMS third party software servers
  • Setup Snapshot replication for reporting and Business Intelligence Team

Confidential, Phoenix, AZ

SQL Server Support & Server Migration Support SQL 2008R2, SQL 2012SP1

Responsibilities:

  • Provided adapt in a dynamic environment, working from varied company and remote locations.
  • Identified and resolved application and SQL issues with blocking deadlocking and perform maintenance as needed.
  • Created/Modified PerfMon counters to track/find issues within Windows Server 2012/SQL using the Server App Tools or Packages Select to process.
  • Received and addressed automated pages from proactive SQL DBMS and database SCOM monitors to identify potential stress issues.
  • Worked independently and on a team in an agile lifecycle environment to ensure communication and liability to our team projects.
  • Planned, developed, and tested data to validate new or modified database applications; monitored system performance by the using appropriate utilities, online tools, and batch reports.
  • Tested, troubleshot, and defined and redefined support documentation on our systems; applied quality assurance, and security standards to ensure against the loss of data, and a minimal interruption of usage in the event of equipment failure.

Confidential, Chandler, AZ

SQL Server Support & Server Migration Support SQL 2008R2, 2012

Responsibilities:

  • Created instances using PowerShell scripting tools to build dimensional and Multidimensional Cubes (SSAS)(Process, Backup, Restore)
  • Supported Cerner Projects CCL while implementing and configuring application specifications
  • Created and Modified set PerfMon counters to track/find application issues within Windows Server 2012/SQL 2012 using the Server App Tools.
  • Ran select queries to manage SQL Server Tables, indexes fragmentation, statistics, and Database Space issues by checking there Growth trends by focusing on Data & Transaction log file growth.
  • Wrote SQL queries to perform ETL processes to retrieve data views with temp tables from relational source systems (SQL).
  • Conferred with programmers/analysts, and customers staff to define functional requirements, perform data modeling and implemented final products; resolved errors and interfaced problems that ensured integrated systems in accordance with development standards.

Confidential, Phoenix, AZ

SQL Server DBA

Responsibilities:

  • Worked independently and on a team in an agile environment. Received and addressed automated pages from proactive DBMS and database Fog light/SCOM monitors.
  • Used service now ticketing system to update teams on blocking issues and to advised on next steps in my task process.
  • Provided adapt in a dynamic environment, working from varied company and remote locations.
  • Administration of Oracle 11g databases running on Linux servers and Microsoft SQL Server including, but not limited to backup & restore, database monitoring, database tuning, database cloning & replication, and database patching. Generating and analyzing 10046 and 10053 traces.
  • Ensured Oracle and Microsoft SQL Server databases are operational 24x7 in multiple SaaS environments.
  • Worked independently and on a team in an agile environment.
  • Received and addressed automated pages from proactive DBMS and database Fog light/SCOM monitors.
  • Created/Modified PerfMon counters to track/find issues within Windows Server 2008,2012/SQL using the Server App Tools or Packages Select to process.
  • Applied Agile methodologies, business intelligence, data architecture definition, and data model design tools, Erwin, ETL, IMS, Oracle databases, SQL, SQL Server, schema development and TOAD to design logical models for new conceptual improvements.

Confidential, Phoenix, AZ

SQL Server Support & Server Migration Support SQL 2008, 2008R2

Responsibilities:

  • SQL Server upgrade and migration from version 2005 to SQL Server 2008
  • Provided adapt in a dynamic environment, working from varied company and remote locations.
  • Administration of Oracle 11g databases running on Linux servers and Microsoft SQL Server including, but not limited to backup & restore, database monitoring, database tuning, database cloning & replication, and database patching. Generating and analyzing 10046 and 10053 traces.
  • Received and addressed automated pages from proactive SQL DBMS, and used Fog light/SCOM monitors for server trends.
  • Planned, defined, structured, developed, and implemented enterprise level database systems on Windows Server 2008 platforms.
  • Participated in Project life cycle planning and heavy full life cycle experience.
  • MSSQL DBA, OLTP) system and star schema (OLAP) including, Decision-Support Systems (DSS), Data mapping, dimensional models including Normalized, De-normalized, Star-Schema & Snowflake Schema and developing strategies for Extraction, Transformation. Design and created an ETL process.
  • Preformed masking of tables by TDE methods for encryption of various tables that PII information on them per FDIC standards

Confidential, Phoenix, AZ

SQL Server DBA

Responsibilities:

  • Administration and maintenance of SQL Server Instances with building our and supporting HIPPA compliant MSBI environments
  • Setup of Replication, Disaster Recovery planning and procedures
  • Performance and Tuning of SQL Server using Index tuning, profiler, PerfMon, DTA, DMVs and DMFs
  • SQL Server upgrade and migration from physical servers to virtual servers version SQL Server 2008
  • Development of Installer package for Data, SSIS Services and required components SQL Upscaling
  • Installed and maintained SQL Server databases, including: ensuring successful backups, resolving system issues, opening cases with technical support to resolve issues, monitoring success and failure of automated jobs, monitor system availability, updating system documentation, system and database recovery, etc.
  • Designed, documented, and promoted security "best practices", policies, standards and protocols.
  • Worked in Active/Active, Active / Passive Cluster environment as a High availability solution with Availability grouping

Confidential, Little Rock, AR

Sr. SQL Server DBA

Responsibilities:

  • SQL Server DBA Infrastructure Build Up from Oracle 8g to SQL 2008
  • SQL Technical Lead for Enterprise solutions with the upscale planning from Oracle 8g to SQL 2008R2
  • Designed, implemented, delivered, and supported RDBMS (SQL and Oracle 8g) and trained Oracle DBAs a backup to perform support within SQL Server 2008.
  • Participated in strategic discussions with a variety of customers and other technical professionals to accomplish enterprise-wide RDBMS objectives/goals.
  • SQL Server upscaling, and migrated from physical servers to virtual servers (4) Servers 515 GB version SQL Server 2008
  • Administration and maintenance of SQL Server Instances into PROD-QA-DEV-DR and MSBI environments
  • Setup of Replication, Performance and Tuning of SQL Server using Index tuning, profiler, PerfMon, DTA, DMVs and DMFs
  • SQL Server upgrade and migration from physical servers to virtual servers’ version SQL Server 2008

Confidential, Redmond, WA

SQL Server DBA

Responsibilities:

  • Collected performance data using standard tools such as PerfMon, SQL Diag, and SQL Profiler. Backup and restore databases, performance tuning, code promotion, and granting user access.
  • Participates in team meetings to plan for future scalable growth and new clients joining the domain(s)
  • Supported Microsoft and its sub domain clients by changing password account and/or creating accounts for clients subscribed to Microsoft.com

We'd love your feedback!