Sql Server Database Administrator

JOSE ANSELMO PEMBA

Address Cell Phone E-mail

Lewiston, Maine. 04240 207-***-**** ad5qxj@r.postjobfree.com Database Administrator

PROFILE QUALIFICATIONS

With 5+ years of experience in IT, as a Certified SQL Server and AZURE Cloud DBA, I have administered and provisioned SQL 2005 to 2019 in Production, Test, Development, and Clustered Environments. I also worked with Several Microsoft Azure Cloud Technologies and features. I am a Highly motivated self-starter with strong interpersonal and persuasive communication, outstanding problem-solving, and active listening skills. Having worked in several agile environments as the only DBA and with teams, my experience spans; Installation and Configuration of SQL Server, Upgrade and Service Pack, Performance Tuning, High Availability and Disaster Recovery/Disaster prevention, Database Refreshes, SQL Server Upgrades and Patches and the preparation and deployment of SSIS packages, Active directory and other Windows server features and Excellent knowledge in Cloud technologies like IAAS, PAAS, SAAS, SQL Server to Cloud Migration, Storage Accounts, PowerShell. SKILLS

● Microsoft AZURE

● On-premises to Cloud Migration

● Geo-Replication, Storage Accounts, Cloud Cost Management

● IAAS, PAAS, SAAS

● Virtualization using VMWare and Hyper-V.

● SQL Server Integration Services - SSIS

● SQL Server Analysis Services – SSAS

● SQL Server Reporting Services - SSRS

● High Availability (HA) and Disaster Recovery (DR) solutions; Traditional Failover Clusters, AlwaysOn Availability Groups, Replication, Database Mirroring and Log Shipping

● SQL Server Monitoring - Inbuilt monitoring tools like SQL Server Profiler, Database Tuning Advisor, Extended Events, and External tools like IDERA

● Using PowerShell to automate processes on my servers.

● Proficient with SQL Server 2005 to 2019, Optimization and Performance Tuning

● Support big databases - 3 terabytes and more.

PROFESSIONAL EXPERIENCE

COMPANY: MaineHealth, WESTBROOK, MAINE

08/2021 - Current

SQL Database Administrator

● Designed, Planned and Migrated deployments of customer on-premises data center/applications to Microsoft Azure.

● Planning the Installation of Microsoft SQL Server 2005, 2008R2, 2012, 2014, 2016, and 2019, building, designing, configuring, Upgrade, migrating, and application of Windows and SQL Patching during scheduled database downtimes after hours to ensure databases are up to date in Virtualized environments.

● Implementation and definition of vigorous Backup and Recovery strategies and Capacity planning following the company's Recovery Point Objective (RPO) Recovery Time Objective (RTO) and Retention Policy.

● Recommending and implementing data security by creating users and assigning permissions based on the minimum level of database access the user would need and with tools like Always Encrypted, Transparent Data Encryption

(TDE), and Dynamic Data Masking (DDM) to secure clients sensitive data.

● Leveraging the uses of in-built software in SSMS such as SQL Server profiler, Performance monitor, Extended Events, DMVs, Database Integrity checks to ensure database integrity, stability, and system availability and other Third-party software like IDERA and SolarWinds Database Performance Analyzer to monitor system health and security.

● Configured High Availability (HA) and Disaster Recovery (DR) Solutions on production systems using Clustering - Always On, Traditional Failover Clustering (Windows Server Failover Cluster - WSFC), Database Mirroring, Replication such as peer-to-peer replication, merger replication and transactional replication and Log Shipping to make sure the databases are always available and participating in disaster recovery testing.

● Managing and providing end-to-end support and problem resolution for SQL Server databases through multiple product lifecycle environments, such as development, and testing to mission-critical production systems.

● Create and update database documentation about company standard procedures, technology features, and production issue troubleshooting.

● Analyze, solve, and correct issues in real-time and provide end-to-end problem resolution such as hardware and software purchases, server configuration changes, and assisting developers with query/index tuning, Partitioning, compression, and statistics to enhance speed and maximize system performance.

● Creating and monitoring maintenance plans and agent jobs that take backups and defragment indexes for query performance.

● Hands-on database tuning and troubleshooting of SQL Server service outages as they occur, including providing On- call support during after-hours and weekends. Providing scheduled maintenance, supporting application deployment, and hardware/software upgrades after hours and 24/7 support.

● Review scripts submitted by the development team and work with other teams like systems analysts, developers, business analysts, and project teams to perform the capacity planning required to create and maintain the Databases.

● Control and establish appropriate database user access control levels by provisioning and de-provisioning users based upon company policy to control access for each segment of the Databases. Develops database security guidelines and performs audits.

COMPANY: ABBOTT LABORATORIES, WESTBROOK, MAINE

06/2020 – 08/2021

SQL Database Administrator

● Installed, upgraded, and configured SQL Server 2012 / 2016 on Windows Server 2019 for several applications with the latest service packs.

● Convert and consolidate systems, and data from disparate sources to a relational management system.

● Implement enhancements that resulted in improved data Quality, availability, and security.

● Manage Infrastructure performance, capacity, and data security and make recommendations for improvements.

● Assist in the monitoring and review of the performance and quality of service provided by the infrastructure.

● Evaluate and implement products to enhance existing database solutions (reduce costs, improve efficiency and performance). Designs and maintains access and security administration,

● Provide technical support to databases, including system management, backup/recovery, account management, configuration, and trouble calls.

● Design and implement comprehensive Backup plans and disaster recovery strategies. Involved in troubleshooting and fine-tuning databases for performance and concurrency.

● Utilize basic PowerShell scripting and removed local admin rights from all users and performed several monitoring tasks via PowerShell as well as creating primary database storage structures (tablespaces, rollback segments, etc.).

● Troubleshoot SQL Server service outages as they occur, including after-hours and weekends. Conduct Root Cause Analysis, Making good use of the monitoring Tools to secure automation of various jobs in the SQL Servers.

● Resolve reports-related issues and Work with management to develop database strategies to support company needs and improve performance.

● Provide DBA support and technical expertise for multiple applications in development, UAT, QA, and production environments and interact with clients, application teams, and project managers to design, implement, and support solutions to meet client needs.

● Develop system documentation for all developed applications databases, processes, and jobs, including flowcharts and data models.

● Participate in on-call rotation and work occasionally after hours or on weekends. COMPANY: TYSON FOOD, INC - PORTLAND, MAINE

05/2019 – 08/2020

SQL Database Administrator

● Maintained and updated instances on Microsoft Windows Server including SQL Server 2019 installation, hardware, design, and enterprise standards and environmental documentation.

● Responsible for Database installation, configuration, customization, patch management, performance tuning, monitoring, and application troubleshooting.

● Recommended and implemented the most effective ways to increase performance some of which include creating indexes, defragmentation, and updating index stats. Creates standard operational procedures and templates.

● Generated prompt responses to tickets, resolved user requests based on priority, and ensured database configuration maintenance in the configuration repository.

● Developed, Tested, and Implemented sound backup and Recovery Strategy including Establishing hot, cold, and logical backup scripts to automate the backup procedures. Compliant with the use of Predict in T-SQL.

● Used IBM MQ to exchange messages across various platforms, such as files, applications, systems, and Services through MCQs messaging queues.

● Installed, and configured SQL databases also installed required patches and upgrades.

● Maintained and achieved high availability of database via coordinating with infrastructure teams to allocate system resources to the database. Analyze new Trends to better educate me and assist the company in the best manner, COMPANY: COBALT INTERNATIONAL ENERGY, LTD. - LUANDA, ANGOLA 06/2014 – 01/2018

SQL Database Administrator

● Installed MSSQL 2012 & 2014 SQL servers with Always on Features.

● Involved in troubleshooting and resolving the performance issues in SAP & and other application database servers, applying different debugging techniques to derive a solution.

● Implemented daily reports to highlight Backup failures, Disk space issues, and Job failures.

● Worked as junior DBA for a Government Land Registration project.

● Worked closely with Database developers on development environments.

● Provided DBA support for production databases.

● Responsible for Installation, Administration, and Maintenance of SQL Server Instances.

● Setup Test, Dev, Staging, and Production Environments and on some occasions provide support on Windows IIS.

● Created Users and assigned permissions based on the level of database access the user would need. EDUCATION & PROFESSIONAL DEVELOPMENT

Bachelor’s Degree in business administration, Atlantic International University (Fl, US); 2014 –2017 Bachelor of Computer Science, University of UTANGA, 2010 - 2013

Contact this candidate