Data Analyst Resource Manager

AMADASUN, NOSA.

P.O. Box ******, Decatur GA *****, TEL: 404-***-****

E-mail: ***********@*****.***

CAREER OVERVIEW:

I have good Functional / Technical knowledge of “Relational Database Management Systems” (RDBMS) concept.

I have over 13 years combined experience in Database Administration, Data Engineering, Information Management and Business Process Management. I am a proven team player, with a great eagerness to learn. I have demonstrated strong inter-personal and analytical skills and an ability to manage changing responsibilities, priorities and deliver time critical projects on schedule.

DATABASE MGT SYSTEMS:,

COSMOS DB (NO-SQL DB), AZURE SQL, SQL SERVER, MySQL, ORACLE, SQL DATAWAREHOUSE

TOOLS:

HDFS, DATA FACTORY V2, POLYBASE, AZURE DATABRICKS, SQL, T-SQL, BRIO,

CRYSTAL REPORTS, POWER BI, AZURE STREAM ANALYTICS.

PROFESSIONAL EXPERIENCE:

Dekalb County Government (Sept. 2007 – Present) – DATABASE ADMINISTRATOR / DATA ENGINEER

Creating Azure Subscriptions, using Azure Portal navigation and Azure resources/budget management

Data Flow Life Cycle management.

Using Azure Data Factory for ingestion and storage of unstructured data into Azure Data Lake Gen2, from disparate sources like applications, LOBS, Cloud and CRM using Azure Data Factory for further exploration.

Preparing, cleaning and transforming stored data in preparation for further analysis using Azure Databricks.

Using Azure SQL Data Warehouse to model and serve data to provide answers to business questions.

Creating a dimensional model of data and a structured model to help understand shape, model, structure and schema of data.

Ensuring that data correctly passes through the different stages of Data Flow Life Cycle and become a basis for a “single source of truth” for BI, Reporting, and Analytics.

Preparing data for use by the Data Scientist for futuristic strategies and the Data Analyst for historical summaries.

Use HDFS to connect to different types of data sources from different sources.

Use Data Factory V2 to create workflow for orchestrating data movement and transformation.

Use Polybase to access and combine relational and non-relational data.

Create and maintain data pipelines into Data Lake.

Implement Azure batch and streaming data workloads.

Implement Azure data visualizations like bar charts and pie charts.

Implement ELT and ETL data processing

Identifying and working with the right data structure for a relational workload and relational data structures such as tables, views indexes, etc.

Identifying, and recommending appropriate PaaS, IaaS and SaaS.

Identify and implement appropriate Azure product including Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure Virtual Machines.

Implement management tasks for relational and non-relational data.

Implement appropriate deployment methods like Azure Portal, Azure Resource Manager, Azure PowerShell and Azure CLI.

Implement data security components like firewall, authentication and resolving basic connectivity issues with on-prem, VNets and internet access.

Deploy query tools like Azure Data Studio, SQL Server Management Studio and sqlcmd utility.

Implement the appropriate Azure data store for non-relational workloads and choosing the right non-relational data offering from Azure Cosmos DB APIs, Azure Table storage, Azure Blob storage and Azure File storage.

Implement and support Azure data services for modern data warehousing such as Azure Data Lake Storage Gen2, Azure Synapse Analytics, Azure Databricks, and Azure HDInsight.

Implement and support data ingestion and processing using Azure Data Factory to create pipelines and activities and also processing options like Azure HDInsight, Azure Databricks, Azure Synapse Analytics, Azure Data Factory.

Migrated databases from SQL Server 2005/2008 and SQL Server 2008R2 to SQL Server 2016 & 2017.

Use Microsoft Database Migration Assistant to migrate on-prem SQL Server to Microsoft Azure VMs.

Implement and support AlwaysOn availability groups for high availability for production servers.

Responsible for supporting the SQL Server databases and ensuring their performance, availability, and security.

Involved in performance testing and optimization of a 2TB OLTP Database server.

Manage the products and development databases including performance tuning, capacity planning, SQL Server clustering, database security configuration, and database continuity.

Managing SQL Server database security by granting permissions securable to the principals and automate

various routine maintenance tasks like backups, index reorganization, index rebuilds on all production

databases.

Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.

Expertise in using DBCC trace flags, handling blocking and deadlock situations.

Using Data availability solutions like Online Restore, Online index operation, Database Snapshot and Fast Recovery.

Pro-actively monitor the database systems to ensure secure services with minimum downtime.

Improve and manage maintenance of the databases to include Deployments and Upgrades.

Responsible for security and non-security patches based on company approved maintenance schedules.

Query optimization and improving overall performance.

Working with tools like Commvault for Backups and SQL Server performance analyzer (SOLAR WINDS) Tool for monitoring the servers.

Develop and create stored procedures, advanced queries, triggers, views, indices, and functions for databases.

EDUCATION:

Masters - Information Technology (M.IT)

Higher Diploma (BSc.) - Surveying

CERTIFICATION / TRAINING:

Oracle Certified Professional (OCP)

Network+ Professional Certification

ITIL (Foundation) Certification

AWS Certified Solutions Architect Associate Certification

Microsoft Azure Foundation Certification

Oracle Cloud Infrastructure Foundation Certification

Azure Data Engineer Associate (DP-200 Implementing an Azure Data solution Exam)

Contact this candidate