Sql Server Data

Kume Arsamo

Falls Church, VA

571-***-****: **********@*****.***

Professional Experience:

NewWave Technologies Inc, Elkridge, MD Feb, 2017– Present

SQL DBA / ETL Developer

Analyze business requirement coming from the CMS and EPPE projects and design and develop Database solutions working with developers and development team.

Administered the Organization’s databases, using database management system to organize and store data, determining user requirements.

Coordinated and applied physical changes to the databases; coded, tested and implemented physical changes to the databases.

Performed variety of tasks related to Database Administrator activities and required.

Monitored VMWare Virtualization technology including capacity planning, building, configuring the VMs specific to IIS, Application, Web and SQL.

Configured and administer ad monitor VMware performance related to SQL Servers.

Worked on SQL Audit using 3rd party tools and native log analysis.

Tested backups to ensure the company meet the business' Recovery Time Objectives (RTO).

Responsible for installation, upgrade and configuration of SQL Server on all dedicated boxes.

Optimized SQL queries for improved performance and reports rendering.

Managed and implemented SSIS packages to do the nightly refresh of data. Performed ad hoc queries and maintained query efficiencies. Worked with users and development staff to determine requirements.

Performed data migration using bulk copy program (BCP) and SSIS. Scheduled jobs and alerts using SQL Server Agent. Used third party performance monitor tools and SQL Profiler to optimize queries.

Prepared various mappings to load the data into different stages like staging1, Staging2 and Target tables. Extensively used Mapping parameters, mapping variables to make mappings more flexible and minimizing hard coding in ETL logic.

Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.

Involved in fine tuning of sql queries in the transformations like Lookup, Source qualifier.

Created reusable Mapping, Tasks, Session and Mapplets and transformations in informatica.

Used Informatica debugging techniques to debug the mappings and used session log files and bad files to trace errors occurred while loading.

Develop packages using SSIS to migrate data from MSSQL environments.

George Mason Mortgage, Fairfax May, 2016 – Jan, 2017

Database Administrator/BI Developer

Designed and implemented multiple high availability technologies (Always-On, Classic Clustering, Log Shipping, Mirroring between multiple locations on both development and Production environments.

Hands on experience on AWS migration and supporting and AWS and RBMS systems.

Checked the general health of the SQL server (space, CPU utilization, memory) to confirm there are no issues, checked the SQL server error logs for any errors that may occurred overnight.

Performed weekly database maintenance tasks such as Re-Building, Re-Organizing indexes and Update Statistics on the Testing and Production Servers.

Designed and maintained BI components such as Reports, Scorecards, Dashboards, and Visualizers using Motivity BI Tool.

Managed CRS (Company Reporting System) Server that is used to develop/generate automated reports, which are received, by executives and branch managers in daily, weekly, monthly and yearly basis.

Evaluated and analyzed new and existing CRS databases and develop data dictionaries and expressions used for reporting services.

Maintained Production Database Servers as Command Center remotely. Also supported the production environment to resolve any Production issues and implemented Replication architecture to replicate data on multiple sites for high data availability.

Worked in importing and cleansing of data from various sources like MS Access, MS Excel, Oracle, flat files onto SQL Server Database.

Expert in Transact-SQL (TSQL) with strong technical knowledge in creating SQL Scripts, Complex stored procedures, Triggers, Indexes, Cursors, various constraints, views, function, and variables.

Developed SQL Solutions for defined tables to generate Loan Origination Systems data for analysis of data using SQL Server 2012 BI Suite (SSRS, SSAS).

Conducted database management, performance measurement and performance tuning for new and existing databases by using SQL Profiler, Database Engine Tuning Advisor and execution plan.

Created users account in CRS and Motivity for new Loan Officers, Branch Managers, and Executives etc and assigned them to report subscription.

Carey International, DC March 2013 - April 2016

Database Administrator

Installing, configuring and maintenance of SQL Server 2008R2/2012/2014 across the Division Department Server.

Installed and monitor AWS along with DMS applications.

Ensure all database servers are backed up in a way that meets the business’s Recovery Point Objectives (RPO) and test backups to ensure we can meet the business’ Recovery Time Objectives (RTO).

Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.

Implemented high availability technologies Replication, Log shipping, and Mirroring between the company’s data centers.

Trended SQL Server Performance using DMVs and PerfCounters.

Monitoring of database size and disk space in Production, Staging & Development environments.

Performing daily, weekly, monthly maintenance backups/restorative exercises (Backup Exec), reviewing server logs for potential issues, as well as by ensuring that anti-virus software and security patches are routinely updated and functioning (Ensuring overall server configuration integrity).

Worked in day-to-day database maintenance operations, database backup-restore, job scheduling in a real time production and Stage environment.

Reviews SQL code and database object designs to standards and best practices.

Creating and managing schema and objects such as tables, views, indexes, stored procedures and triggers and maintained referential Integrity.

Migrated SQL Server 2005/2008/2008R2 into new versions of SQL Server 2012/2014.

Implemented backup strategies, scheduling backups and restoring them when necessary.

Managing the use of disk space, memory and connections. Running DBCC consistency checks and analyzing stack traces, if generated, fixing data corruption on application databases.

Supported development and test databases for ongoing development and testing.

Coordinates with the Hosting team on Branch offices server build documentation, help with evaluating those document to ensure they are applicable to the branch offices realities.

Dunatek Consulting, Silver Spring, MD Feb. 2009 – Sept. 2013

SQL Database Administrator

Installing, configuring and maintenance of SQL Server 2005/2008R2.

Configured various events driven e-mail notification process in SSIS packages.

Creating users and assigning permissions for Windows and SQL Authentication.

Created user defined data types and added them to model database for future use.

Database system configurations, database consistency, and queries optimization.

Maintaining Development, Testing and Production servers in sync.

Applied database backup compression and adjust storage to make backups perform faster.

Installing SQL Server service packs based on the errors and flaws that are found in the application.

Resolving various performance issues and running DBCC commands, SQL Profiler and Performance Counters.

Perform Full Backups, Differential and Transactional Log Backups and restore them whenever necessary; creating backup strategies and scheduling them for execution.

Working with customers on Application rollouts and server migrations.

Converting DTS packages into SQL Server 2005 Integration Services.

Migrated SQL Server 2000 databases into SQL Server 2005/2008.

EDUCATION:

Bachelor of Science in Information Technology, AAU

Tools and Technologies:

●RDBMS: SQL Server 2000, 2005, 2008 and 2008R2, 2012, 2014

●Database Tools: SSIS, SSAS, SSRS

●BI Tools: MicroStrategy, SAP, Motivity/Movation, Encompass360 and SQL Server Reporting Services (SSRS)

Contact this candidate