Sql Developer Dba

CAESAR ASIMIGA

T* Quincy circle, Dayton, New Jersey,08810 • Home: 678-***-**** • Cell: 678-***-**** • *******@*****.***

Education:

Bachelor of Science in Computer Science - Kwame Nkrumah University of Science and Technology, Kumasi, Ghana

Master of Science in Database Engineering University of Maryland (in progress)

Certifications:

Microsoft Certified IT Professional (MCITP)

Microsoft Certified Technology Specialist (MCTS)

CompTIA+, Network + Certifications

Skills Summary:

Excellent written and oral communication, good team player, highly motivated, ability and willingness to learn, detail oriented and result driven DBA with more than 10 years’ outstanding experience in SQL server Database Administration, installation, configuration, migration, patches and upgrades, maintenance, monitoring, troubleshooting and performance tuning of the production and non-production databases to ensure availability, reliability, confidentiality, security and integrity of the company’s data.

Great experience in High Availability and Disaster recovery solution; database mirroring, replication, log shipping, always on availability groups and backup & recovery. Experience in Recovery Point Objectives (RPO) and Recovery Time Objectives (RTO), working Knowledge in MS SQL Azure cloud; IAAS, SAAS and PAAS solutions, HANA. Database logical, conceptual and physical design, Database development and deployment, Indexes management, DMVs, Activity monitor, Perfmon, DBCC utilities, SQL Profiler, Database Engine Tuning Advisor, T-SQL query performance tuning, Execution Plans, Maintenance plans, Stored Procedures, Triggers, Views, SQL Server jobs scheduling, monitor disk space, CPU activity, SSIS ETL, SDLC, STLC, Execution of Test Cases and defect Reporting.

TECHNICAL SUMMARY:

Databases

MS SQL Server 2008/2012/2014,2016,2017,2019, MySQL, Hana, Access

Languages

SQL, Transact-SQL (T-SQL), PL/SQL, XML, HTML

Operating Systems

SERVER 2012/2016 / UNIX/ LINUX

SQL Server Tools

SSMS, SSCM, Aqua Studio, SQL Profiler, SQL Query Analyzer, MS SQL Server Index Tuning Wizard, Perfmon, Activity monitor, Database Engine Tuning Advisor (DETA), SQL Developer, Toad, Easy Vista, Jira, BMC Remedy.

IDE & BI Tools

SSIS, ETL, SNAP MANAGER.

PROFESSIONAL EXPERIENCE:

Securities America, Omaha, NE 06/2018 – 1/2019

SQL Server DBA

Performed Installation, Patching, Monitoring, Trouble shooting, and Performance tuning and daily support for MS Microsoft SQL Servers.

Applied Policy based management principles to ensure standard documentation, management, maintenance, administration, monitoring and services.

Ensured that the security of the database is maintained by periodically reviewing user access to ensure that users who no longer require access to the database are removed from access.

Maintained, managed and administered SQL Server clusters and servers. Configured and managed standalone servers.

Configured database replication, log shipping, Mirroring.

Assisted developers with complex query tuning and schema refinement

Maintained and utilized policies and procedures for database security and integrity.

Configured table partitioning in prod, test and dev and SMTP configuration of SSRS Servers.

Review, Create and execute stored procedures, import, export and BCP data.

Interacted with developers daily to resolve Tickets using BMC Remedy ticketing system.

Performed twice a week production database deployment.

Undertook Data Migration, Data change capture and, Data masking projects using DDDP and Database auditing for securities America. Used Aqua studio and SQL Server management Studio to manage SQL Server databases in Production, Development and Test. I used Extract, Transform and Load (ETL)method move data.

Used snap manager for snap copy backup and native backup and restore methods.

Used TFS and SharePoint for scripts and documentation management.

Responsible for database migration from SQL Server 2012to 2016.

Implemented High Availability and Disaster Recovery (HA/DR) solution.

Used DMVs, Activity monitor, DTA, DBCC utilities, SQL Profiler, explain plan, etc. for trouble shooting.

PROFESSIONAL EXPERIENCE:

Wipro (Chemours Company) Wilmington, DE 01/2018 – 06/2018

SQL Server DBA NORTH AMERICA

Responsible for Database Design, Development, Deployment, monitoring, trouble shooting, performance tuning, database Security, Integrity and Availability, Database security, installation, patches, upgrades and Database supports for continuous improvement of uninterrupted operations in Production, Development and Test databases.

Assist developers with complex query tuning and schema refinement

Created databases, Tables, Constraints, Indexes, Views, Stored Procedures and Triggers using T-SQL and PL/SQL

Performed database migrations, configured maintenance plans, automate Agent jobs, created operators and alerts, Database backups and restores, Configure and supported High Availability (HA /DR) and Disaster Recovery (DR); Always on availability group, replication and log shipping, Used DMVs, Activity monitor, DBCC utilities, SQL Profiler, Extended events, Tuning advisor, Indexes, Statistics and explain plan.

PROFESSIONAL EXPERIENCE:

Stone Resource Group (Health Port) Alpharetta, GA 01/2015–12/2015

SQL Server DBA

Performed development, configuration, updating, migration, security, patches, performance tuning and providing 24x7 dedicated supports to all Production database administration.

Use SSIS for ETL for Data import and Export.

Used SSRS create reports for management

Performed database logical and physical design, maintenance, tuning, archiving, indexes, replication, recovery, software upgrades, capacity planning and optimization for SQL Server database.

Managed and administered 2500+ database in 100 instances with 20 servers.

Configured and supported replication and log shipping in 2008 and 2012.

Performed day to day DBA activities such as backup and restore, monitoring SQL Server health, job status and addressing user requirements.

Monitored and optimized system performance using DMVs, Activity monitor, DBCC utilities, SQL Profiler and Database Engine Tuning Advisor.

Optimized T-SQL query performance using SQL Profiler, Execution Plans, and DMV's.

Provided DBA support and technical expertise for multiple applications in development, test, QA and production - SQL Server 2005, 2008, and 2012, 2014, 2016 environments.

Scheduled full, differential, and transactional log backups for user created databases.

Used Microsoft SQL Server Integration Services (SSIS) platform (ETL) for extraction of data, transformation of data, and loading the data into destination/ data warehousing.

Worked with several teams and lead database team in the process of development of a Disaster Recovery and high availability solutions.

Contact this candidate