RUPERT EDANG
Phone: 713-***-****
Email: ************@*****.***
MSSQL SERVER DATABASE ADMINISTRATOR PROFILE
Over 6 years of professional IT experience, with more than 5 years of experience as a Microsoft SQL Server Database Administrator. Great hands-on experience in Database Designs, Installation, Migration, Performance Analysis, Development, general Support of SQL Server for versions 2019/2016/2014/2012 in Production, Development, Test, Cluster, and Replication Server Environments. A highly qualified, goal-oriented IT professional with extensive SQL Server troubleshooting skills. Experience working with high profile customers, both internally and externally, and have an excellent verbal, and communication skills. Great hands-on experience working with multiple MSSQL Server tools like: MSSQL Server Management Studio
(SSMS), Database Engine Tuning Advisor, Query Adviser, SQL Profiler, Data Transformation), Upgrade Wizard, Replication, SQL Reporting, SSIS, Solar Winds, Adera, A proactive DBA who is Ready to Learn and implement New Technologies. PROFESSIONAL EXPERIENCE FEB 2021 -PRESENT
AMAZON HOUSTON TX
SQL Server Database Administrator
- Installation and configuration of new instances of SQL Server
- Implement best practices on Microsoft SQL Server Databases and Servers.
- Monitor databases using inbuilt SQL Server tools and external tools
- Create and Manage SQL server Users, Roles and Privileges (Principal of Least Pre- villages).
- Plan and implement database backups/restore based on company’s SLA
- Manage indexes (update statistics) to improve performance
- Schedule jobs, configure alert and monitor using SQL server agent
- Maintain database security at high priority following company security policies.
- Update security tables, database auditing and limiting data access to defined groups.
- Upgrade SQL Server databases from SQL Server 2012 to SQL Server 2019
- Performance tuning and Query Optimization
-Exposure to Azure Fundamental (Cloud Computing)
-24/7 On-Rotation Database Administrator Experience
- Setup Always on Availability groups for High Availability and Disaster Recovery
- Participate in Project planning and Management
- Document Processes and Procedures for Future references
- Interact with developers, application team and project managers Land Master LLC March 2020 – Jan 2021
San Antonio Texas
SQL Server database administrator
- Installation of SQL Servers Instances using Microsoft best practice
- Implement HADR for all business-critical databases (Always on, Log shipping, Database mirroring and replication)
- Implement/or improve database monitoring and capacity management tools globally
across all data centers to detect performance issues and prevent potential outages before they occur
- Achieve maximum performance gain for overall database performance
- Implement In-memory technology for heavy used databases
- Improve top 5 batch jobs to at least 20% in performance gains
- Upgrade all SQL Server databases from SQL Server 2012 to 2014/2016
- Apply Patches and Cumulative Updates to SQL Instances
- Perform health checks and monitor database server performance
- Proactively monitor and tune slow running queries
- Administer database security, Data encryption (TDE, AE and DDM)
- Implement database maintenance plans
- Design and implement data replication strategies (transactional, snapshot and merge)
- Configure database instances as per industry’s best practices Orange Cameroon June 2016 – December 2019
Junior SQL DBA / Data Entry specialist
- Install and configure SQL server 2012
- Use the monitoring tools to identify queries and optimize
- Make recommendations to improve and gain efficiency for existing processes
- Assist the database team and IT group with other administrative needs
(maintenance,
backups,
- Monitoring, production incident resolution
- Assist in the product release process
- Review requirements and adhere to regulatory body guidelines and IT best practices
- Communicate change management procedures
- Help with other database projects and set goals to increase efficiency. Education and Certification
- SQL Server Microsoft Technology Associate.
- Bachelors’ degree in Computer science, obtained from the University of Buea.