add photo
George
gadjaidoo@gmail.com
lyrixg@gmail.com
301-452-2385
Finksburg, MD 21048
23 years experience W2
0
Recommendations
Average rating
225
Profile views
Summary

  • Over 14 years of experience in database analysis, database design and development in SQL 2014/2012/2008/2005/2000 in production and support environment
  • Expert in SAS
  • Expert in Shell Scripting Linux, Unix systems
  • Expert in PowerShell
  • Expert in Automation Solutions
  • Experience in High Availability / Disaster Recovery (HADR) solutions Failover Clusters AlwaysOn Availability Groups, REPLICATION, Log Shipping Mirroring.
  • Experienced in Upgrade / Migration of MS SQL SERVER 2008 TO MS SQL SERVER 2008 R2, FROM SQL SERVER 2012 SQL SERVER 2014.
  • Experience working WITH application team implemented databases as per the specification FROM LOB applications.
  • Experienced in installation, configuration, maintenance optimization of SQL SERVER HADR solutions.
  • Experienced in BACKUP Recovery, Query Optimization Security.
  • Experienced in monitoring the health performance of SQL servers as well as home grown applications using SQL SERVER native tools several other third party solutions.
  • Adept at T
  • SQL, stored procedures, tables, indexes, VIEWS, functions, triggers.
  • Expert in creating DTS packages TO utilize SSIS functionalities
  • Strong knowledge of Relational Database Management Systems (RDBMS) concept
  • Experienced in designing complex reports including sub reports and formulas with complex logic using SQL Server Reporting Services (SSRS)
  • Worked on activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SQL Server SSIS. Change Data Capture, Slowly Changing Dimensions, etc.
  • Experienced in data import/export, data migration between homogenous system using Data Transformation Service (DTS) Packages, Bulk Copy command (BCP) and Bulk Insert.
  • Experienced in Data Warehouse/Data Mart methodologies Kimball vs. Inmon
  • Experienced in XML data exchange XBRL
  • Experienced in XML to SQL Server data base using SSIS
  • Experienced in XML messaging
  • Experienced in XML Shred and Writing using XQuery, XPath
  • Experienced in SQL service broker
  • Experienced in Advance T-SQL querying programming, string manipulation, dataset manipulation like Dynamic Pivot, UNPIVOT, Cross Apply, CTE, Cursors, while loops, Etc.
  • Experienced in Advance analytic functions windowing functions in SQL Server (LEAD, LAG, PERCENTILE_CONT, ROW_NUM)
  • Expert IN using DTA / Extended Events / PerfMon / SQL Profiler / Scripts and other third party tools to resolve bottlenecks, dead locks

Experience
Education
Accounting
University of Maryland 2009
Information Systems/Accounting
Montgomery College 2002
Certifications
Microsoft Certified Professional-Database
EDX (MOOC) - Querying with Transact-SQL Certified
COMPUTER EDUCATION
Skills
SSIS
2021
7
SQL
2021
5
ETL Developer
2021
4
Business Requirements
2021
3
Data Integrity
2021
3
Data Mapping
2021
3
Data Warehousing
2021
3
Database Backups
2014
3
Java
2021
3
Linux
2021
3
Microsoft Excel
2021
3
MS SharePoint
2021
3
SDLC
2021
3
Stored Procedure
2014
3
System Design
2021
3
XML
2021
3
Agile Methodology
0
1
Data Marts
0
1
Data Migration
0
1
Data Mining
0
1
Data Modeling
0
1
Data Replication
0
1
Database Design
0
1
Database Management
0
1
Disaster Recovery
0
1
Erwin Data Modler
0
1
ETL
2017
1
Hadoop
0
1
HADR
0
1
JSON
0
1
Mirro
0
1
Oracle
0
1
PowerShell
0
1
Risk Management
2008
1
SAS
0
1
Scripting
0
1
Shell Scripts
0
1
Software Engineer
0
1
SQL Server
0
1
SSRS
0
1
T-SQL
0
1
Triggers
0
1
UNIX
0
1
Waterfall
0
1