Sql Server Database Administrator
Resume:
Suliman Kamara
*************@*****.***
Experience Summary
Accomplished Database Administrator with 3 years of IT and related experience. 3 years as Oracle DBA and 3 years as MS SQL server DBA. Worked on operating systems like Unix, Linux, Windows and AIX. Experience include Installation, Upgradation, Patching, Migration, Cloning, Memory Management, Performance Monitoring, Troubleshooting, Backup and Recovery, Database security, System maintenance, Database design and Modeling, Capacity planning, Documentation, Application support and deployment. Ability to write and maintain high quality documentation.
Areas of Expertise Include:
Installation, Configuration and capacity planning
Performance monitoring and tuning
Backup and recovery
Database security and Migration
Upgrades and Patching
Oracle Rac and ASM
Oracle Data Guard
Bash/Unix shell scripting and Automation
Technical skills and Tools:
Installation, configuration and upgrade of Oracle 10g 11g, and 12c using OUI, DBCA, DBUA Oracle Date Guard configuration and Administration (Using Broker)
Work with various operating systems including UNIX (Solaris 8/9/10), Oracle ASM and RAC
LINUX (RED HAT) and MS Windows servers 2008,2012, 2014 and 2016 Database Migration using Data Pump Utility
Monitoring and performance tuning using AWR, ADDM, OEM console, Grid control, Database security including DTIE
SQL Developer. Explain plan, Optimizer Statistics. MS SQL Server Management Studio
Backup and recovery using RMAN and Maintenance plan Wizard. MS SQL Server Configuration Manager
SQL, PL/SQL, T_SQL, UNIX Shell Scripting
WORK HISTORY:
Preston IT Consulting LCC, Saint Paul, MN February 2024 _ present
Oracle Production Support DBA
Install and configure Oracle 10g, 11g, and12c software on UNIX/ LINUX operating system.
Fixed various database performance issues using Automated workload Repository
(AWR). Automatic Database Diagnostic Monitor (ADDM) and Active session History (ASH).
Strong in analyzing how oracle resources are being used during SQL executions.
Identify long running database queries, refine queries for better performance,
and working with end _users to implement changes.
Involve in session management and monitored the critical wait events, blocking sessions in the database.
Experience in database upgrade using both DBUA and manual method, and database patching.
experience in managing oracle RAC for high availability.
Successfully configure and manage Data Guard for disaster recovery, data protection and availability.
Performed Data Guard ran over as required for maintenance. This includes coordinating with application
Owners and sys admis to when the failover can be performed.
Perform data and metadata migration to newly installed servers using Data Pump Expdp/Impdp.
Experience in data replication using snapshot, materialized views and delinks.
Create database objects like views, procedures, functions, triggers, tables, synonyms, and indexes.
Plan and perform Backup/Recovery using Rman based on SLAs, test backup for corruption, work with flash Recovery Area as well.
Extensively worked on complete and incomplete recoveries of the database including point in time recovery (PITR) and Tablespace point in time recovery (TSPITR) using RMAN utility.
Clone production databases as needed for testing, development using RMAN.
Work on database security including Auditing (standard auditing, fine grain, valued based and statement auditing), Encrypting (Transparent Table ENCRYPTION).
Hands on experience in UNIX scripting.
Apply oracle quarterly patches and interim patches to databases using patch utility.
Experience in monitoring oracle instances and maintaining databases performance using OEM (Oracle Enterprise Manager 12c).
Use SQL Developer to connect to database, navigate tables inside databases, create tables and other databases objects with GUI, insert data into tables and create reports.
Involved in each phase of the lifecycle (SDLC) including requirement gathering, technical design, development, system integration phase,
quality assurance phase, development, and production support activities.
Part of the 24/7 on call production support team.
Lineage Logistics:
Cdl _ Class A Regional Driver at Westborough, MA November 2021 to present
Deliver frozen and/or refrigerated freight to and from local locations
Provide excellent customer service to our customers while delivering quality products to each location and/or store
Maintain schedule to ensure on time pick-up and delivery; may be required to read out the digital tachograph timely Account for and inspect freight to prevent rejection or potential claim issues.
may include checking the loading temperature and monitoring it during transport Ensure accuracy of paperwork with the delivery,
and that all requirements are met in coordination with the dispatch and operations departments
Maintain accurate and up to date driver logs for hours of service and equipment maintenance.
Food Authority, INC:
Cdl_ Class A local delivery Driver at Westboro, MA August 2018 to October 2021
Ensure shipment of temperature-controlled and undamaged product, proper
count of goods at customer locations, assuring inventory levels are FIFO in the customer locations.
Management of Driver Apprentice/Helper.
Drive vehicles to designated destinations for customer product deliveries.
Drive safely and deliver products within deadlines.
Load and unload products from trucks or trailers.
Put product away based on customer specifications.
Maintain driving log, prepare vehicle performance forms, and complete daily paperwork.
Follow DOT regulations and safety standards.
Follow set, scheduled route for daily deliveries.
SYGMA:
Cdl at Sygma Foods-Shrewsbury, MA August 2015 to July 2018
Delivering food to Panera Bread, Jenny c. Wing stop, Texas roadhouses.
Independent Sales Representative 5linx.
Worcester, MA September 2010 to April 2015
Responsibilities provide customer with products and services. Accomplishments customer satisfaction,
make people get better services like, energy, phone services, high speed internet, TV, home security, small business services.
Manufacturing Associate Eaton.
Worcester, MA February 2006 to September 2010
Responsibilities_ provide products and power quality operations Accomplishments help make the jobs a health and safety place to work.
Skills_ Using fabricates, paints, assembles, shipping and materials handling.
SQL Server Production Support DBA
Install, configure and maintain standard and Enterprise editions of SQL Server 2008,2012, 2014, and 2016.
Successfully apply service packs on various software versions, migrate and update SQL server databases from older to newer versions.
Experience in using SQL server configurations Manager to set up job scheduler SQL server Agent.
Perform day to day database security tasks such as login issues, access privileges, installing client software on pc, creating and managing tables and indexes.
Manage records capture for auditing including C2 audit tracing (for US Government Agencies).
Proficient in database backup and recovery models (both physical and logical backups).
Use a varied range of backup optimization techniques including incremental backup, backup stripping, backup resilient or mirror, compressed backup and backup with checksum.
Use SQL Server Maintenance plan Wizard to check database integrity, perform index maintenance, update database statistics, and perform backup job scheduling.
Expose to backup and recovery to Microsoft Cloud using URL/windows Azure.
Proficient in Data Movement (Import & Export) while performing partial backup of database objects such as full table, multiple tables, entire schema or entire databases
Using both Generate and Publish Script Wizard and Command Line based.
Create test database copies using Copy Database Wizard.
Hands on experience with analyzing query plan, using extended procedures, managing indexes, statistics and locks to troubleshoot and resolve database issues.
Education:
Oracle Certified Associate (OCA)
Certificated in Emergency Medical Technician (EMT)
Certificated in Electrical Wiring
Sustainable farming
Commercial Driver’s License (CDL _A)
University of Phoenix Business Management and Technology
Quinsigamond Community College__ General Studies, EMT, and Electrical Wiring Advance
Work Authorization Status: U. S. Citizen
Contact this candidate