Database Administrator Sql Server

TUAN CRAINE SHERIFF SALLY

*** *********** ******, ******, ** 92879.

Cell: 714-***-**** ****.*****@*****.***

EDUCATIONAL PROFICIENCIES

COLLEGE:

BACHELOR IN SCIENCE BUSINESS ADMINISTRATION-MAJOR IN COMPUTER INFORMATION SYSTEMS, AND ASSOCIATE DEGREE IN DATABASE MANAGEMENT SYSTEMS, COMPUTER PROGRAMMING, AND BUSINESS ADMINISTRATION.

TECHNICAL PROFICIENCIES

Languages: .NET 2.0/3.0/3.5/4.0, VB.NET, C# 4.0, MVC 3.0, Delphi 6/7/8, T-SQL, Python 3.7 Jupiter Notebook, Microsoft C++.

Databases: SQL Server 2000/2005/2008 R2/2012/2014/2016/2017/2019, Access Platforms: Windows 9x/NT/2000/XP/Vista, Windows 7 and 10, Oracle VM VirtualBox Manager, VMware.

PROFESSIONAL CERTIFICATIONS

Python certified from LinkedIn Learning.

AWS Certified Cloud Practitioner.

Certification of completion in Learn Azure step by step with Udemy.

Microsoft qualified MCITP and MCTS in MS SQL 2008 as a Database Administrator.

Online Certification in MSBI, SSIS, SSRS and SSAS conducted by Udemy.

Certification in MySQL 8.0 Database Administrator with Udemy.

CIS Professional Certification in C++ programming.

CIS Professional Certification in Object-Oriented Design & Programming.

Certificate of Completion in Ultimate Hands-On Hadoop – Tame your Big Data online course conducted by Udemy.

CIS Professional Certificate in SQL using MS SQL Server.

Certification of Introduction to Computer Information Technology.

Diploma in Computer Science at Open Arch, Sri Lanka.

Diploma in Advanced Programming Techniques at IDM Computer Studies (Pvt.) Ltd.

MS SQL Server 2005/2008 DBA/Management course at New Horizon Computer Learning Center.

Certificate in Oracle SQL & PL/SQL 11g version

Advanced Programming Techniques, C/C++.

Certificate in ASP.net.

Certificate in Delphi 6.

DynCorp Leadership training 201.

Certified QMS Internal Auditor.

Certified OPSEC Awareness for Military Members, DOD Employees and Contractors.

Basic Programming Course in Micro Intelligence in 1993. PROFESSIONAL EXPERIENCE

MS International Inc. 06/2022 – Up to date

APPLICATION DATABASE ADMINISTRATOR (AZURE MS SQL SERVER 2016 – 2021)

Monitoring 66 databases in production environment blocks and deadlocks.

Building the new SPs on the requirement of DB alerts.

Responsible for database backups and disk space management.

Managing and administrating the application user permissions.

Working collaboratively with the development team to optimize their scripts, SPs, and functions.

Database migration and database upgrades.

Setting up new Failover clusters and Always On for database Synchronous.

Database Installation and Configuration:

Install and configure SQL Server instances, ensuring proper setup of environments for development, testing, and production.

Database Maintenance and Monitoring:

Perform routine maintenance tasks such as backups, integrity checks, and index maintenance. Monitor database performance and optimize as necessary to ensure high availability and performance.

Security Management:

Implement and manage database security policies, including user roles and permissions, to protect data from unauthorized access.

Performance Tuning and Optimization:

Analyze and optimize SQL queries, indexes, and database structures to enhance performance and efficiency.

Data Recovery and Backup:

Develop and implement disaster recovery plans, ensuring regular backups and the ability to restore data quickly and accurately in the event of data loss.

Troubleshooting and Support:

Diagnose and resolve database-related issues, providing support to application development teams and end-users to address performance and connectivity problems. WEB SITE DATABASE ADMINISTRATOR (MYSQL 5.7 – 8.0) IN WINDOWS AND LINUX ENVIRONMENTS.

Managing and maintaining the MySQL web service databases.

Upgrading and migrating MySQL databases.

Setting up events to archiving the database and for backups.

Collaborate assistance to developers on their script and SPs optimizations. MAMTIS SOLUTIONS LLC. CORONA HILLS, CA 07/2020 – 04/2021 DATABASE CONSULTANT/ADMINISTRATOR/ANALYSIS (SHORT-TERM CONTRACT)

Meeting client’s requirements in database solutions.

Discussing and planning business future goals and suggesting database structures.

Helping the client with their required suitable Microsoft Software plans.

Suggesting and advising the required software and adequate IT infrastructure for their business.

Helping to purchase the required software and hardware.

Migrating On-site MS SQL database into AWS RDS or MS Azure.

Installation and setting the client’s MS SQL Server database, MYSQL or PostgreSQL databases.

Providing training and other database-related assistance to the client. MINKA LIGHTING LLC. CORONA, CA 04/2019 – 04/2020

DATABASE ADMINISTRATOR FOR HIGHJUMP APPLICATION (MS SQL SERVER 2010 R2)

Maintaining the HighJump data integrity.

Troubleshooting the HighJump user issues with calibrating with HighJump Technical support.

Maintaining the HighJump database backups.

Assist and setting up warehouse operator facilities with HighJump RFD Scanners.

Monitoring the HighJump database using the 3

rd

Party tools (SolarWinds DPA/SQL Sentry)

Granting access to new employees to the HighJump application and administering the use accounts.

Assisting the ETL developer on SSRS and Crystal Reports. Office Star Products – Ontario, CA

MSSQL DBA (MS SQL Server 2008 R2 and 2016) 09/2016 – 04/2019

Develop and maintain T-SQL and SQL-CLR code objects (SP, Triggers, Function, and views) that support OSP’s internal and mission-critical external applications.

Monitoring application developer’s T-SQL skills.

Maintains and troubleshoots existing backups, replications, and distributed data.

Develop and maintain SSRS (SQL Server Reporting Services) reports, data sets and data sources and deploy them the SharePoint.

Developing and maintaining SSIS (SQL Server Integration Services).

Analyzes performance bottlenecks and provides appropriate solutions.

Monitors system and application performance and tunes applications.

Managing and tuning OSP Azure database.

Managing the high availability applying log shipping and failover recovery to the main server with automated SQL jobs.

Database server maintenance (DB Indexing, DB Shrinking and DB Backups)

DB Customer support for MS Dynamic GP and Accellos applications.

ETL (Extract Transfer Load) data from MS Dynamic GP and Accellos applications.

Developing new business analysis modules for internal use.

Installing and Upgrading MS SQL applications for new VM Servers. Self Employed – Chino, CA

DB Consultant, DBA and Developer 10/2015 – 08/2016 Consulting small business owners to convert to paper less data warehouse. Making their data accurate and building convenient reporting systems on their figure tips. (7- Eleven Norco, HCTC and Tropical Drinks) DynCorp International LLC. – Fort Worth, TX/Muscat, Oman WRM-Program Lead Database Administrator (MS SQL Server 2008 R2 and 2012 R2) 10/2009 – 09/2015 DynCorp International LLC., is a US Air Force Contractor for War Reserve Management System worldwide, with the super vision of AMIC and AFCENT.

Always keeps the servers up and provides users with access to the required information when they need it. Ensures that the database is protected and that any chance of data loss is minimized. Carries out all duties in accordance with DynCorp ISO 9001 Quality and Safety Standards.

Monitors and assists Site DBAs with maintenance of Site Database Servers.

Installs and upgrades SQL Servers.

Monitors the database server’s health and tunes accordingly.

Ensures the server is running at optimal performance.

Monitoring Replications (Subscription and Distribution) on all 5 WRM sites to head office.

Uses server storage space efficiently.

Performs backup and recovery duties.

Establishes standards and schedules for database backups.

Develops recovery procedures for each database.

Ensures that backup schedules meet recovery requirements.

Manages database user access and security.

Coordinates maintenance with Database Developers.

Transfers data to/from the database to/from other applications.

Replicates database only as directed by authorized personnel.

Performs data warehousing and schedules database maintenance.

Provides 24-hours access to authorized users.

Servers as Trainer of Users on database administration.

Coordinates efforts with LAN Administrators.

Project Management (Distributing work to our contract vendors). DynCorp International LLC. – Muscat, Oman

Senior DBA/ Database Developer (MS SQL Server 2000 R2 and 2008 R2) 06/2003 – 10/2009 For the proper analysis, design, implementation and maintenance of databases and associated interfaces to support the WRM program. Adheres to all aspects of the ISO 9001 program.

Provides Lead in design to programmers while Lead Database Developer is not available.

Provides Lead to programming issues.

Accepts direction and requirements from Lead DB Developer and Business Process Analyst.

Converts business requirements into logical database designs.

Creates databases using appropriate tools and security.

Creates Crystal Report templates as required.

Designs user interfaces to maintain data.

Provides Backup and restore of existing databases as required.

Set-up replication agents when required.

Set-up Logins, roles and permissions when required.

Set-up SQL Servers when required.

Developing required Data Transforming Systems (DTS) for the WRM application

Developing and managing the replication process.

Maintaining the current database in SQL2000. Creating Stored Procedure, Triggers, Views, and Replications. Also granting permission for the users in the database.

Analyzes existing databases and recommends upgrading or re-engineering, as appropriate.

Performs other duties as capabilities and requirements dictate.

Ensures all work is completed to appropriate quality standards. Secondary Duties:

Accepts direction and requirements from Lead DB Developer and Business Process Analyst.

Converts business requirements into logical database designs.

Creates databases using appropriate tools and security.

Designs user interfaces to maintain data.

Implements databases on WRM networks and provides user training.

Implements databases on WRM networks and provides user training. (On-line Assistance)

Analyzes existing databases and recommends upgrading or re-engineering, as appropriate.

Performs other duties as capabilities and requirements dictate.

Ensures all work is completed to appropriate quality standards.

Error handling (help desk).

Report generated according to the management and create new reports to the management with Crystal Report 10.

Front end is in Delphi 7.0

PROFESSIONAL MEMBERSHIPS

Microsoft Certified Information Technology Professional (MCITP)

Microsoft Certified Technology Specialist (MCTS)

AWS Certify Cloud Practitioner

PROFESSIONAL REFERENCES:-

• Bryant Griffith

Database Administrator for KAIHONUA

Contact #. +1-240-***-****

• Velia Orefice

Professor at Mt. San Antonio College

Contact #. +1-951-***-****

Contact this candidate