BOBGA CLAUMAN

SQL Server database administrator

Location: MN Email:ad03q7@r.postjobfree.com Phone: +1-651-***-**** LinkedIn PROFESSIONAL SUMMARY

• Highly skilled Senior Database Administrator with over 7 years of hands-on experience supporting Microsoft systems in complex enterprise environments.

• Proficient on Microsoft SQL Server Database Installation, upgrading, Configuration, Administration, Maintenance, Performance Tuning, Backup & Recovery experience in SQL Server 2019/2017/2016/2014/2012/2008 & 2008R2 On-Premises and on AZURE cloud environment.

• Comprehensive knowledge and experience in all phases of the Software Development Life Cycle (SDLC) and great working experience in an Agile/SCRUM development team.

• Experience in implementing SQL Server Security, object permission, maintaining creation of users, configuring permissions database authentication and assigning roles of users.

• Extensive working experience in troubleshooting, monitoring and performance tuning various issues.

• Extensive experience in implementing HADR solutions such as Always on Availability Group, Replication, Log shipping, Clustering and Mirroring on physical and virtual machines.

• I am an expert in Data conversion, Data modeling, Normalization, Data Scrubbing, Data Staging and Data Validation in preparation of pushing data to production environment.

• I am highly proficient in using T-SQL scripts, Views, Triggers, and knowledgeable in Common Table Expressions (CTE), Functions, stored procedures that meet business requirements.

• Experienced in creating ETL process, Data warehousing, Operations Data Store concepts, data marts, OLAP technologies, and knowledgeable in Star and Snowflake schema.

• Experienced in creating and deploying ETL packages to move data from various heterogeneous data sources such as Access, Excel, and CSV Flat files.

• Well Experienced with Microsoft SQL Server Integration (SSIS) and Reporting Services (SSRS).

• Well experienced in managing very large databases with minimum to no downtime, strong understanding of RDBMS concepts as well as Data Modeling Concepts.

• Experienced with Policy Based Management, Resource Governor, Transparent Data Encryption, Always Encrypted, Dynamic Data Masking and Contained Database. • Proficient in defining and enforcing database standards, policies, security and documentation. • Excellent analytical, problem-solving skills, written and verbal communication skill at all levels and great attention to detail

TECHNICAL SKILLS

Languages T-SQL, Windows CMD, PowerShell, Shell Scripting Database tools MS Azure, SSMS, SSIS, SSRS, SharePoint, Index Tuning Advisor, Database Engine Tuning Advisor, SQL Profiler, Performance Monitor, Activity Monitor, DMVs & DMFs, Policy

Based Management, Resource Governor, DMA (Data Migration Assistance), Azure Database Migration Service, Data Stage, Runbooks, hung processes. Third party tools IDERA, Red Gate, DD-Boost, Commvault, Net-Backup, Jira, Service Now, Splunk, Locks MS Tools Access and Excel, MS-Access, MS-Outlook, MS-Teams Build/Release Automation Git, Jenkins, Bitbucket, Testing Data, EDUCATION

BBA: Business Administration and Management JUN 2016 National Higher Polytechnic University, Bamenda, Cameroon WORK EXPERIENCE

BRIDGE ICT CONSULTING - LAKELAND, FLORIDA JULY 2021 - Present SQL Server Database Administrator

• Create and configure Logical SQL servers, databases, elastic pools in Azure Cloud. Import and Export data within Azure Cloud environment. Installed and configured SQL Server 2012, 2014, 2016, 2019, 2022following Microsoft best practices.

• Creating and Managing logins/Access levels in Azure IAAS and PAAS environments.

• Ensuring a successful monitor of resources And Log Analytics Able to configure automatic tuning, recovered azure deleted databases and able to recover databases to a point in time.

• Monitoring standby Databases to ensure high availability Setup Database Mail and Operator to alert whenever any automated job fails. Participating in Agile/Scrum calls including weekly sprints and daily standups.

• Manage and maintain SQL Server instances in IAAS and PAAS environments.

• Perform SQL Server installation, configuration, backup, and recovery procedures.

• Optimize database performance by creating and implementing indexes, views, and stored procedures.

• Develop ETL processes and create reports using SSIS, SSAS, and SSRS. Utilize Azure Data Factory and Azure Synapse for data integration and analysis. Implement security measures to ensure data confidentiality and integrity.

• Uses Database tool for PowerShell scripts for automation of database administration tasks.

• Provide technical support to end-users and troubleshoot database-related issues. Ensure high availability and disaster recovery procedures are in place. Implemented Spring Boot Microservices to divide the application into various sub modules. Proficient in responsive web development using Bootstrap and Media Query.

• Proficient in resolving tickets and user requests, following change management process using ServiceNow.

• Developed effective Database Migration procedures to migrate from on-prem to Azure.

• Designed and created databases, tables and other database

• objects using T-SQL and GUI. Configured and supported replication and log shipping in both SQL2012 and 2014. LUTHERAN SOCIAL SERVICES INC- SAINT PAL, MN SEP 2016 – JUN 2021 MSSQL Server Database Administrator

• Provided 24-hour Production support for mission-critical databases in a complex environment.

• Installing & patching, configuring, and administering SQL server 2008R2/2012/2014/2016/2017 & 2019 SQL servers on

• Physical/ Highly Virtualized datacenters (on premise) and on MS AZURE Cloud environments.

• Supporting SQL Databases on Azure Virtual Machines (IAAS) and Azure Managed Instance (PAAS) hosted in Microsoft Azure. Involved Disaster Recovery planning and DRE (Disaster Recovery Exercise) testing. to support SLA.

• Implementing proper backup and recovery strategies by following the RTO and RPO of the business requirement.

• Executing database baselining, benchmarking, performance analysis, and tuning.

• Managing Server level and Database level security in accordance with the security policy of the company, protecting against potential vulnerabilities and also preventing data from unauthorized access by best security practices for HIPPA compliances. Reviewing SQL database changes and deploying changes, SSIS packages, and reports.

• Review T-SQL scripts to verify and meet standards for both performance and error handling according to procedures and policies. Owning, tracking, and resolving database-related incidents and change control management tasks, reviewing tables, views, indexes, and stored procedures utilizing best practices.

• Attending project planning meetings, participating and contributing to decision making and problem-solving processes.

• Managing and maintaining SQL Server databases, including database backups, restoration, performance tuning, and security.

• Installing and configuring SQL Server software and tools, as well as configuring the server, network, and other components.

• Upgrading and migrating SQL Server software and databases to newer versions or different environments.

• Implementing and maintaining SQL Server high availability and disaster recovery solutions, such as clustering, replication, log shipping, and Always on Availability Groups.

• Monitoring and tuning SQL Server performance, including query optimization, indexing, memory and disk usage, and other metrics.

• Managing SQL Server security and access control, including user accounts, roles, permissions, and auditing.

• Monitoring SQL Server activity, identifying and resolving issues, and troubleshooting errors and alerts.

• Implementing and maintaining backup and recovery strategies, including backup schedules, storage, and retention policies. Forecasting SQL Server resource usage and capacity requirements and recommending hardware and software upgrades as needed.

• Developing and testing disaster recovery plans and procedures and ensuring business continuity in the event of a disaster. SQL Server Patching and Maintenance: Installing and applying SQL Server patches, updates, and hotfixes, and performing routine maintenance tasks

CERTIFICATION

• Certified Azure Database Administrator Associate (DP 300).

• Certification for Microsoft Azure Data Engineering (DP 203) in Progress.

• Certified Microsoft Azure Data Fundamentals (DP-900)

• Certified Microsoft Technology Associate

• Certified Microsoft SQL Server

• Certified Professional Scrum Master (PSM 1)

• Certified Microsoft Office

Contact this candidate