Resume

Sign in

Data Sql

Location:
Arlington, TX
Posted:
December 21, 2019

Contact this candidate

Resume:

Patrick Damisa

ada4c8@r.postjobfree.com

501-***-****

Experienced Microsoft SQL Server DBA with over 5 years knowledge of providing strategic guidance, administration and support on all Microsoft SQL Servers. This includes implementing alerting/monitoring, review design decisions, conducting code reviews. Strong knowledge on cloud transition/migration, Availability Groups, Clustering, AlwayOn, database performance issues with expert ability to recommend and implement appropriate solutions.

Very detail-oriented with strong analytical and problem-solving skills who is comfortable with SQL Server DB utilities, monitoring, backup, and recovery, expert in SQL Server security, resource management, data integrity, performance tuning.

Technical Skills:

SSIS, T-SQL, AzureSQL, Availability Groups, Clustering, AlwayOn, SQL Server 2008, 2012, 2014, 2016, 2017.

Ability to work with minimal supervision, engaging peers and other departments to accomplish assigned goals and effectively manage projects in a cross-functional environment.

My educational background offers a unique blend of both computer science and Information technology.

Experience and Competencies:

MPIT Houston, TX USA

Consultant: Microsoft SQL Server DBA

(February 2019 - Present)

• Install, configure, and manage SQL database servers

• Maintain high levels of performance, availability, sustainability and security

• Perform SQL Server troubleshooting: analyze and resolve issues correct and efficiently

• Implementing and managing High Availability (HA) and Disaster Recovery (DR) options for SQL Server (Replication, Mirroring, Clustering, and AlwaysOn)

• Gather requirements and propose deployment outlines

• Perform 24x 7 scheduled and emergency technical support

• Refine and automate regular processes, track issues, and document changes

• Tuning and optimizing database performance

• Upgrades and Patches to SQL Server and Azure installations.

• Responsible for performing backups and restores

• Perform database, table migration.

• Create, maintain, and administer SQL Server databases within company policies and/or best practices

• Ensure databases are highly available, highly secure, and recoverable

• Monitor and tune the databases for maximum performance

• Work with software developers and testers to provide optimization help, performance stabilization, and index tuning.

• Troubleshoot and solve database and database coding issues

• Ensure secure services with minimum downtime (SQL Server).

• Responsible for improvement and maintenance of the databases to include rollout and upgrades.

• Responsible for implementation and release of database changes.

• Plan growth and changes (capacity planning)

• Develop SQL/T-SQL queries.

• Run and maintain all remote and local data replication jobs Cott Beverages Arlington TX USA

Microsoft SQL Server DBA

(May 2016 - December 2018)

• Ensured high levels of data availability and database performance

• Collaborated with application teams on best practices and maintain a healthy, learning culture

• Collaborated with project teams to provide SQL database expertise to support company needs

• Tuned and optimize SQL Statements, Instance Parameters, and Data Storage, including the identification of performance-related issues

• Responsible for indexes, buffers, and cache

• Develop SQL/T-SQL queries.

• Responsible for database migration

• Work with Data Base Engineering on release engineering to apply best practices for data base interfaces to improve data base execution and performance

• Apply best practices and tools to analyze, debug, and resolve database performance issues

• Work with operations on improving the monitoring of data base performance, capacity, and availability

• Maintain high availability environments using failover clustering/availability groups (AlwaysOn)

• Evaluate and make recommendations for adjustments to accommodate capacity proactively

• Maintain security policy and procedures for data base servers and secure content

Conagra foods Russellville Arkansas USA

Microsoft SQL Server DBA

(November 2014- March 2016)

• Manage and support multiple Development, Test and Production SQL applications environments

• Perform cloning, patching, and code migrations as necessary to support business requirements

• Provide and maintain documentation on database systems, configurations, processes and standards.

• Support 24/7 applications with strong understanding of backup and recovery best practices.

• Work with IT applications teams to ensure database requirements are met. Protect data from inappropriate access or data loss. Perform security reviews.

• SQL and T-SQL Scripting

• Upgrades and Patches to SQL Server and Azure installations.

• Database backup and recovery.

• Trouble shooting and performance tuning.

• SQL Server standardization.

EDUCATION

Arkansas Tech University, Arkansas USA

MSc Emergency Management and Homeland Security

(2015-Ongoing)

Career in Work Keys Assessment System

Applied Mathematics, Locating Information

and Readiness for Information.

Issued by the state of Arkansas.

(April 2012)

Nigerian Institute of Information Technology, Lagos Nigeria Certificate in Windows System Administration.

(December 2005)



Contact this candidate