Sql Server Software Development

DANNY KEDEM AMENIGY

********@*****.***

LinkedIn Profile: www.linkedin.com/in/danny-kedem-amenigy-68a177b3 SKILL SET

• Support databases such as Postgres, SQL Server 2019, Oracle, MySQL, Maria DB and Redshift

• AWS monitoring Services such as: Cloudwatch, Performance Insights, enhanced monitoring

• AWS networking such as: NACLs, Subnets, Route Tables, Security Groups, etc

• AWS services such as: Elastic Cloud Compute (EC2), Lambda, EBS, S3, VPC etc.

• Adequate knowledge of scripting jobs: CRON, Python, Perl, Bash.

• Programming languages such as: C#, Python, Visual Basic, etc

• Database Migration: AWS DMS, Oracle RMAN, EXPDP and IMPDP, SQL Server Native backup and Restore, Postgres and MySQL replication.

• Limited Theory knowledge of Jenkins on AWS

• AWS Cloudformation template

• AWS Security and IAM roles and policies

• Database Migration: SQL Server to SQL Server, Oracle to SQL Server, MySQL to SQL Server, and MS Access/Excel to SQL Server

• Operating System: Windows Server 2019

• Languages: SQL, T - SQL, HTML, DHTML, XML, JavaScript, ASP, ASP.net EXPERIENCE

MAY 2021 - PRESENT

CLOUD POSTGRES DBA, CREDIT UNION LOAN SOURCE

• Migrating SQL Server databases into AWS postgres

• Managing a Data Warehouse for all our analytics and reporting

• Developed ETL processes for ingesting data in our postgreSQL warehouse

• Enforce security and backup policies for data integrity and durability

• Rewrite legacy reports generated from SQL Server to Postgres APRIL 2019 – MAY 2021

CLOUD DATABASE ENGINEER, AMAZON WEB SERVICES

• Created new databases, involving importing and exporting: installing and configuring

• Learn, support, and use groundbreaking technologies

• Drive projects that improve support-related processes and our customers’ technical support experience

• Apply advanced troubleshooting techniques to provide unique solutions to our customers’ individual needs

• Work on critical, highly complex customer problems that span multiple AWS services 2

• Learn, support, and use groundbreaking technologies

• Support databases such as Postgres, SQL Server, Oracle, MySQL, Maria DB and DMS JANUARY 2018 – APRIL 2019

ORACLE DATABASE ADMINISTRATOR, CHAVERAN INSTITUE OF TECHNOLOGY

• Created new databases, involving importing and exporting: installing and configuring database software for Oracle Application development environment.

• Created AWR reports for the senior DBAs and performed tuning based on their recommendations given to improve the efficiency of the database servers.

• Handled database sever tuning, application tuning, maintaining documentation, capacity planning and database security.

• Involved in all phases of database development from needs assessment to quality assurance, design and support.

• Implemented backup and recovery procedures of databases in Red Hat Linux environment: implemented backup and recovery procedures and IT department manual.

• Supported Oracle developers. Performed database tuning, created database reorganization procedures, scripted databases alerts and monitored scripts.

• Create and execute scripts.

• Provided development and design assistance to development and other application support teams.

• Migration of on-premises databases 11g and 12c to AWS cloud services. NOVEMBER 2016 – DECEMBER 2017

APPLICATION DBA, MICRO ALERT

• Identify bottlenecks and bugs, and devise solutions to mitigate and address these issues.

• Develop web based software using C# and maintained the databases on Maria DB and SQL Server 2012.

• Managed database remodeling and interface development during upgrades to the latest version of the Maria DB application.

• Read data models, create and implemented database scripts for our on-premises environment. Build deploy DB scripts in deployment, QA, staging and production environments.

• Assisted other Product Development and IT organizations.

• Assisting clients with disaster recovery tryouts.

• Assisted the Database developers and project managers in the software development life cycle.

• Perform on-site support when required.

• Installed, Configured, and Maintained SQL Server 2014, 2012, and 2008 R2 in development, test, and production environment

• Configured and Maintained Fail-Over Clustering using SQL Server 2012

• Maintained server and database security including database encryption (TDE)

• Installed and Configured SQL Server Reporting Services (SSRS)

• Developed and deployed different types of Reports using different data sources like SQL Server, Oracle, Excel, CSV files

• Delivered reports to users in variety of formats like Report Server (Web based), excel, pdf, html, excel and CSV formats

• Configured and Maintained Replications, Log Shipping, and Mirroring for High Availability.

3

• Upgraded/Migrated SQL Server Instances/Databases from older version SQL Server to new version of SQL Server like 2000/2005 to 2008 R2 and 2008 R2 to 2012

• Migrated MS Access Databases into MS SQL Server 2008 R2, and 2012

• Migrated Oracle 10gR2/11gR2 and MySQL 5.1.23 databases to SQL Server 2008 R2/2012

• Applied SP (Service Pack)/ Hot Fixes on SQL Server Instances to address security and upgraded related issues

• Performed database and SQL/TSQL Performance Tuning

• Wrote SQL/T-SQL queries, Stored-Procedures, functions, and Triggers MARCH 2016 – OCTOBER 2016

JUNIOR DATABASE ADMINISTRATOR, HAHN & HAHN INC.

• Contributed in the development and maintenance of IP2008 software suit.

• Maintaining client documentation including database topology, connection procedures, and special instructions.

• Able to work on multiple projects simultaneously.

• Supported the Maria DB database.

• Coordinated activities with supervisor and other DBA’s.

• Use Team Foundation Services to collaborate and control codebase of our projects. March, 2015 - November, 2015

Project Leader – Academic, Belgium Campus IT VARSITY This position required the project leader to collaborate with a team of 7 pupils assigned by my supervisor to design, develop and implement a document consistency workflow project that will be used by lecturers on campus. The project was developed using ASP.NET for the front-end, C# as the business logic and MYSQL as the database storage. This project was completed on time and under the budget.

• Managed a team of 8 students including myself and was responsible for keeping the project on time, on track and under budget.

• The project was to develop a System workflow.

• Performed routine audits on work done on the project.

• Assigned duties to the right personnel in the group and maintained an inter- personal relationship with all group members.

• Reported regularly to the lectures on project progress.

• Maintained documentation of milestones completed. EDUCATION

JANUARY 2013 - MAY 2016

BACHELOR OF COMPUTER SCIENCE (SOFTWARE ENGINEERING & DATABASE ADMINISTRATION, BELGIUM CAMPUS ITVARSITY

APPLICATION SECURITY SPECIALIST WITH IBM

UTILITIES & TOOLS

• SQL Tuning : SQL PLUS, SQL Developer, Oracle Enterprise Manager

• DB Servers: Oracle 11g, Oracle 12c, Maria DB 9, MySQL 5.6, MS SQL 2012

• Configuration and Connection: DBCA, ASMCA, LSNRCTL, SSH, VPN services, Remote Desktop 4

• Others: Visual Studio 2010 – 2016, NetBeans, GIT HUB, Team Foundation Server

• AWS Cloud Database Services

Contact this candidate