Sql Server
Resume:
Phyllis
Atabongakeng
Upper Marlboro, MD 20774
*********@*****.***
Experienced SQL Database Administrator for over 6 years extensive experience in installing, configuration and administration of MS clustering. Extensively involved in 24/7 Production support of the databases and round-the-clock database operations SQL DBA activities include but not limited to Installation, configuration, importing/exporting, patch installs, capacity planning, backup and recovery of mission critical databases, Implemented a recovery plan to a point in time failure. Responsible for data security and Integrity with HIPAA requirements. Ability to troubleshoot day-to-day problems encountered on production as well as development database environments with SQL Monitoring services. Experience writing SQL queries, Stored Procedures, Triggers, Functions, creating Tables, Views and Indexes. Implement and maintain database security, replication, SQL Clustering, Stand by server, DTS, SSIS, Log shipping, Database Mirroring, SQL Mail, SQL Scripting, Database Migration, Data Normalization. Excellent analytical, communication skills, work ethics and ability to work in a team environment with strong determination and commitment.
Skills
Operating System
SQL server 2008/2012/2014/2016
Production & FQT, VB.NET
Application/Tools
Aqua data studio, SharePoint, Air watch, IBM, Blackberry Enterprise, JIRA
Experience
03/2017–6/2018
SQL Administrator / Modis/Dignari, Washington DC
Manage all SQL content, configurations, and search databases.
Contracted SQL DBA for ICE
Run transaction log backups to truncate logs.
Create new content databases as needed.
Create maintenance schedule for databases.
Mirror data to disaster recovery sites.
Patch the MS SQL Server and MOSS environments per ICE’s security baseline.
Manage the SharePoint farm.
Perform all farm level administrative tasks.
Performance monitoring for SharePoint farm and all collections, sites and content databases.
Manage, create, deletion, backup, and restore site collections.
Resolve farm and server level helpdesk requests.
Data analysis, modeling, mining, forecasting, and extraction
Conduct quantitative and qualitative reporting using data systems and summarizing findings and recommendations in reports
Excel, Access, SQL, Oracle, query building
08/2015 – 11/2016
Database Administrator / Patient Matters, Lake Buena Vista FL
Responsible for the installation, configuration, operations and maintenance
Responsible for troubleshooting database issues
Responsible for applying regular database patch and database upgrade
Aid in administering enterprise applications that rely upon SQL Server databases.
Tune performance of the environment including databases, tables, views/queries and stored procedures.
Install, upgrade and configure SQL Server and related patches; perform all database maintenance, backup and recovery activities.
Develop and write stores procedures, functions, queries, and view in Transact-SQL as needed
Set up and administer database security; provide user privileges in development, test and production database.
SQL Scripting, Database Migration, Data Normalization
07/2014 – 07/2015
SQL Server DBA / Jeunesse Global, Lake Mary FL
Support of High Availability and Disaster Recovery options for SQL Server
Index, Query and Performance Tuning activities
Security planning and environment documentation
Provides technical expertise in the use of database technology
Accountable for the overall performance of the enterprise's database environment
Monitors and analyzes performance metrics and allocates database resources to achieve optimum database performance
Perform operational DBA duties: installation, database upgrades, patching, environment cloning, implementing backup/recovery and monitoring procedures, capacity planning, site failover/switchover, SQL Scripting, Database Migration, Data
Manage monitoring / capacity management processes to ensure appropriate scale of growth
Maintain expertise in MS SQL Server DBMS, logical and physical database design best practices
01/2013 – 07/2014
SQL DBA / Info Zen, Annapolis MD
configuration, security, failover, and optimization of databases in high availability environment
Hands-on experience with automation of tools, implementations, scripting and database reporting metrics and reports.
SQL experience writing complicated queries from scratch, tuning other’s code, analyzing impacts
SAN storage system, backup/recovery/fail-over methods and best practices
Excellent written and verbal communication skill. Ability to write clear documentation of operation procedures and ability to write detailed and ability to write detailed specifications.
Education
12/2018
Information System Administration / UMUC
Clearance
Public Trust
Contact this candidate