Sql Server Database Administrator
Resume:
A team worker, detail-oriented and highly organized.
Strong analytical and problem-solving skills with the ability to clearly articulate solution alternatives.
Ability to create, design, migrate and monitor availability, security, and integrity of databases.
Ability to automate with PowerShell.
Ability to Perform SQL Server Database operations using GUI and T-SQL Scripts.
Ability to install, configure, and set up MS SQL Server instances and OS on-prem and in the cloud.
Knowledge of creating Virtual Machines, configuration, and Cloning. (Virtualization).
Creating a Vm and promoting the Vm to become a Domain Controller.
Ability to create and give permission to users and groups in Active Directory.
Create, initialize, and allocate Disk space on various drives based on workload.
F
N
SKILLS & HIGHLIGHTS
WORK HISTORY
MSSQL Database Administrator 05/2021 to Current
TURNING POINT Inc Newburyport, MA
•Create and establish working partnerships with various business groups and companies on their technology, application development and communication network quality
•Assist with windows server configuration and management as it relates to MSSQL server installation and performance
•Worked with system DBA team by performing backup, restore and archival tasks on Database Management systems
•Assist developers with all the database activities
•Assist with development of standards and policies around data security and access (end-user access vs developer access)
•Protect databases from hackers and prevent them from any misuse by using strong authentication and authorization controls
•Manage and execute daily operational jobs including index/statistics updates
•Work closely with project managers, application developers and system administrators on new and ongoing projects
•Establish document and maintain standard framework and procedures for the development and management of the company's IT infrastructure
•Provide support to the network and Application developer teams in improving database connection and other database objects to ensure quality and high performance
•Finding DMV queries to resolve issues about server level performance
•Determine the most effective way to increase performance including server configuration changes, index/query changes and hardware purchase
•Work with network support, server, and disk storage teams to facilitate, manage and balance systems
•Assisted in operations of telephone call history data retrieval from the database
•Identify performance problems and modify database to improve performance
•Identified the need to develop and deploy a database as well as Database system
SUMMARY
Ready to relocate if necessary
Salem MA
ad2ov1@r.postjobfree.com
Detailed-oriented SQL DBA with over 8 years of hands-on experience on windows and the cloud. Have worked with dynamic teams in providing 24/7 and round the clock security, performance, and production support to database systems. Performing daily SQL DBA tasks such as installations, Configurations, checking database health, Performance tuning, monitoring database activity, high availability solutions. importing /exporting Data, database Backup & Restore, database migration, Server and database level Security implementation, Disaster Recovery measures, for high availability and optimum performance. A team worker with analytical, Logical thinking and writing skills. Always striving to learn and implement cutting edge technologies and best practices.
NICHOLAS FONDONG
MSSQL DATABASE ADMINISTRATOR
Knowledge of using SSMS to perform, manage and monitor different Databases tasks.
Knowledge of Pre-sizing data and Log files to keep Auto growth consistent to avoid fragmentation.
Ability to perform backups and restore operations for critical / production databases.
Ability to Schedule and monitor SQL Server Agent jobs and create maintenance plans. Ensure server level and database level security applying the principle of least privilege.
Ability to create and grant permission to new users (Logins) to access a database.
Prevent Data breach by implementing SQL Server security best practices such as Data Encryption protocols, Database, and server firewalls, setting up inbound and outbound rules, granting permission to users/groups, Principle of least privilege, using separate database servers, database activity monitoring, using strong user Authentications, performing regular backups of Databases.
Knowledge on High Availability and Disaster Recovery measures for MSSQL in case of disasters.
Ability to optimize queries, performance tuning, create and interprete indexes and Execution plans.
Knowledge of setting up High Availability solutions; mirroring, Replication, clustering, AlwaysOn.
Step-by-step Documentation of processes to keep up with a good knowledge sharing policy within the team and the entire company for future issue tracking remedies.
Event log and server Error log troubleshooting.
Database Mirroring
Instance Replication
Judgment and Decision-Making
Data Conversion and Migration
Running Backups
Patch Management
SKILLS & HIGHLIGHTS
WORK HISTORY
MSSQL Database Administrator (Cont…)
•Make sure that Database behaves in a controlled manner as its needed to be
•Assisted in Modifying and debugging databases when required
•Participated in replacing old databases with new ones while making sure there is always a backup available in case something goes wrong.
•Worked with staff to develop and implement procedures to prevent data loss and maximize system availability.
•Administered, supported, and monitored databases by proactively resolving database issues and maintaining servers.
•Set up and controlled user access levels across databases to protect important data.
•Modified databases to meet needs and goals determined during the planning process.
•Set up and controlled user profiles and access levels for each database segment to protect important data.
SQL Server Database Administrator 10/2018 to 05/2020
Nextel Telephone Network BUEA
•Worked on planning and implementing MS SQL server security and database permissions
•Participated in writing and reviewing T-SQL scripts for creating tables, constraints, stored procedures, views, and functions for critical business applications
•Installation of SQL in a Clustered environment
•Set up maintenance jobs
•Implemented best practices and built Disaster Recovery models to guarantee continuity of business in case of Human or Natural Disaster situation
•Performance Monitoring and Performance Tuning
•Documented step by step processes for installations, troubleshooting, availability group setup, and hot fixing for future issue tracking solutions
•Maintained database response times in 24/7 Production environments
•Planning and implementation of Database backup/restoration and disaster recovery
•Managed Database Security by creating, assigning appropriate roles and privileges to Users based on User activity
•Implemented database mirroring to ensure high availability of critical databases
•Established backups for SQL server 2016 by using SQL server Agent jobs for periodic backups
•Used Execution plans, performance monitors and DBCC commands to find slow running queries to get the performance metrics
•Performed Database Migration from an On-Premises SQL environment to Azure Database in the cloud
•Developed and Implemented Disaster Recovery Plans
•Tested and Implemented different Physical and Logical Backup and Recovery methods and Point-in Time, Recovery.
•Managed workload independently but collaborated with colleagues to complete larger scale tasks in distributed team environment.
•Followed standard practices for migrating changes to test and production environments.
MSSQL Database Administrator 02/2014 to 08/2018
Marc Rich Company LTD DL-Cameroon
•Participated in the creation/cloning of database instances for testing and production purposes
•Assist in production database support and issue resolutions
•Performed database backup/restore activities
ADDITIONAL INFO
Availability/ Location, Phone Intervie 24 – 48-hour notice In Person Intervie 24 – 48-hour notice, To Start: As soon as needed Location:, Ready to relocate if necessary
EDUCATION
Bachelor of Science: Computer Networking and Software Engineering 06/2013
Institute of Technology Cameroon
REFERENCES
AZIWUNG RAMSIA
Turning Point Inc
Program Manager
ALEM FOTABE QUEEN
Marc Rich Company LTD
Supervisor
MANDELA MAYO
Nextel Telephone Network Buea
Zonal coordinator
WORK HISTORY
MSSQL Database Administrator (Cont…)
•Assisted in developing and implementing the technical procedures, standards, and security for databases
•Participate in on-call rotation and working occasionally after hours or on weekends
•Monitor and optimize the performance of databases
•Provided Support on Performance Issues during Project Development, resulting in improved response times and reduced latency
•Responsible for performing, monitoring, and troubleshooting Log shipping
•Configured Always on Availability Group and Log Shipping
•Used Aways On High Availability technology to increase database performance
•Performed database Migrations, patching, and upgrades
•Perform daily maintenance including monitoring backups, managing disk space and maintaining database objects
•Monitoring and responding to alerts from notification from client databases
•Provide database security administration such as User ID's, passwords, roles, privileges, and user profile
•Responding to database mail and notification alerts
•Monitored several Servers for failed jobs and multiple performance issues
•Performed daily Health Checks of all Databases
•Rebuilt indexes at regular intervals per Microsoft recommendations for better performance
•Performed Backups, DBCC utilities, create indexes, monitored database and disk space
•Assist with designing high availability solutions
•Perform Database Design/Database Modeling
•Used Activity Monitor and SQL Profiler to optimize queries and enhance the performance of database servers
•Designed and implemented comprehensive Backup plan and disaster recovery strategies.
•Administered, supported, and monitored databases by proactively resolving database issues and maintaining servers.
•Built databases and table structures for web applications.
Contact this candidate