Post Job Free

Resume

Sign in

Sql Server Ms

Location:
North Arlington, NJ
Posted:
August 18, 2023

Contact this candidate

Resume:

LARBI EJJAKI

Kearny, New Jersey ***** 551-***-****

ady079@r.postjobfree.com linkedin.com/in/larbiejjaki

DATABASE LEADER

Innovative DB Architecture Cloud Migration Business Continuity Cost Optimization Summary

Technical leader supporting and managing multiple database engines on site and public clouds. Consistently achieve organizational goals by directing multiple projects and implementing robust database solutions that incorporate a wide range of applications and technologies impacting revenue by optimizing business performance. Provide technical support and direction to the teams. Ensures that the goals and objectives of the teams are established and implemented to support the strategic initiatives of the organization.

Expertise includes:

– IT Project Team Leadership – Licensing & Operation Cost Optimization

– Database Support, Architecture, Design & DR – Replication, High Availability & Data Guard

– Database Migration to the Cloud – Root Cause Issue Troubleshooting Databases: MS SQL Server, Oracle, Mysql, Azure SQL, CloudSQL, PostgreSQL Public Clouds: Azure, Google, and Amazon.

Languages: SQL, PL/SQL, Shell & Power Shell scripting. Platform: Linux, Windows, OVM, KVM, Sun Solaris .

Skills

● Built a motivated, self-sufficient and trustworthy database management team.

● Provide leadership and guidence in goal setting, training, staffing, and motivating both onshore and offshore.

● Enthusiastic IT & Database Leader. Manager and Technical Lead for Microsoft SQL Server, Oracle, Mysql, Google Cloud Platform, Microsoft Azure, Oracle on Amazon Cloud, and Oracle E-Business Suite on premises.

● Plan and manage database design, installation, configuration, and maintenance activities across multiple database environments.

● Strong knowledge of DataGuard, RMAN, Log Shipping, database mirroring, Data Migration, Linux, Sun Solaris, Windows systems, and storage.

● Proficient in database architecture, high availability, disaster recovery, and clustering.

● Manage department staff including hiring, performance management and career development to ensure alignment with defined goals.

● Apply specific technical expertise in depth to address technical and business issues.

● Extensive experience in database migration to the Cloud, data center/database consolidation, and licensing optimization.

● Manage and forecast team and project resources to ensure adequate capacity for meeting projects, support, and system maintenance.

● Partner closely within the multiple IT departments, customer facing teams, compliance, PMO, and vendors .

● An expert in database consolidations to reduce licensing cost.

● Energized about cultivating an inclusive culture where everyone brings their whole selves to work

● Define the guidelines, best practices, secure the databases, naming conventions, backup and restore strategies.

● Ensure that project milestones & goals are met while adhering to approved budgets & SLAs.

● Team player with demonstrated ability to work well with others to achieve a common target.

● Additional management skills Six sigma, PMP, and performed OPex and CAPex budgeting exercises and management of budget.

PROFESSIONAL EXPERIENCE:

Manager, Database management Services

TelevisaUnivision, Teaneck, NJ 2001 - Present

● Managed multiple DBA teams both onshore and offshore in accomplishing the daily requests and all the project goals.

● Ensure adherence to relevant regulatory requirements and company Standard Operating Procedures (SOPs) as appropriate

● Managed & supported Microsoft SQL Server, Oracle, Mysql on premises and on Microsoft Azure Cloud, Google Platform Cloud and Amazon Cloud.

● Managed, planned, and executed the migration of the database to Google Cloud SQL, GCE, and BMS.

● Expert in database system architectures and implementations both on premises and on the Cloud including high availability and disaster recovery.

● Performing capacity monitoring and short and long-term capacity planning in collaboration with development resources, system administrators and system architects

● Established guidelines for database sizing and capacity planning.

● Propose alternative architectures and solutions to improve end user experience at lower TCO.

● Managed, planned, executed the upgrade of all MSSQL databases to MS SQL Server 2019.

● Managed, planned, and executed the migration of all Oracle instances to Oracle 19c.

● Managed, planned, and executed the migration of all Oracle instances from OVM to KVM.

● Managed, planned, and executed the migration of multiple MS SQL databases to SQL Azure

(PaaS) & Azure VM (IaaS).

● Managed, planned, and executed migration of MS SQL databases to Cloud SQL (PaaS) & MS SQL gce (IaaS) in Google Platform Cloud.

● Managed, planned, and executed the migration of Oracle to BMS in Google Platform Cloud.

● Provides advanced expertise in solving complex technical issues encountered by database operations staff and identifies and implements best practices and strategies for databases.

● Managed many migrations, consolidations, and business continuity projects to lower the cost & improve availability.

● Create, manage, and maintain strategy, standards, roadmaps, and new technologies.

● Effectively meet all deliverables and schedule of all the projects.

● Manage and operate the databases on Production, DR, and all lower environments.

● Commitment to achieving 99.999% uptime of all OLTP production databases.

● Manage Oracle E-Business Suite and upgrade its database on Production, DR, and all lower environments.

● Responsible for setting up plans, priorities and any type of maintenance and projects.

● Lead meetings with the application owners and stakeholders to make decisions about related database activities, maintenance, and current and future projects.

● Excellent skills in managing multiple projects at the same time.

● Perform database administration including database backups & restores using RMAN & native SQL tools, DataGuard, log shipping, database mirroring.

● Identifying and initiating resolutions to user problems/concerns associated with database server equipment (hardware and software). Outstanding problem solving and organizational skills.

● Identifying potential service level problems before they occur and notifying appropriate parties

● Client relationship management.

● Tested and evaluated new products.

● Logging support cases as necessary and effectively working with Oracle Corporation to resolve issues

● Maintaining up-to-date plans for disaster recovery and failover capabilities and high availability as required using Multiple zones/regions on the Cloud, Log shipping, Always-On, mirroring, Rman, DataGuard, Master-Slave replication and Veritas Cluster VCS.

● Proposing solutions, identifying tools, and generating procedures to ensure an efficient, consistent repeatable environment

● Managed and supported database 24x7x365.

Senior DBA & UNIX System Engineer:

PSINet, Web Hosting Center NYC, NY 2000 - 2001

Managing DBAs on different data center locations.

Establish departmental procedures, metrics and work flow where none previously existed. Oracle HA and Veritas Clustering software, Solaris. Responsible for managing, maintaining and securing all the customers' Oracle databases environments. Define the architecture of the database environment, mentor and direct technical database staff and consultants, consult other business units on database issues, and manage database-related projects.

Build UNIX servers, install and configure Solaris 2.6 or higher on Sun Enterprise Servers E250 & E450. Install and configure Veritas Software, StorEdge Systems, and RAID.

● High Availability 24x7 database support experience with large, high capacity oracle systems in a Veritas clustered environment.

● Oracle 7, oracle 8, oracle 8i and Oracle DBA experience in a Solaris and NT environment.

● Physical and logical design using ERWIN.

● Database backup, maintenance, restore, and documentation.

● Performance tuning / optimization, database monitoring

● Oracle Enterprise Manager OEM.

● Veritas Software: File System 3.3.2, Volume Manager 3.0.3 and Cluster1.1.

● Load, configure and patch Solstice Disksuite/Veritas Volume Manager software (logical volume management) as required. Load and patch Veritas File System software as required.

● Administer the production HA clusters running Veritas Cluster r 2.1. Perform fail-over when required for system maintenance.

● Build and configure UNIX servers E250 & E450. Install Sun Solaris 2.6 &2.7 using Jumpstart server.

● Architect, requisition, configure hardware and build servers for various purposes.

● Perform hardware problem diagnosis and maintenance on all systems.

● Troubleshoot complex Solaris hardware/software/network related issues.

Senior Oracle Database Administrator:

Federal Reserve Bank, NYC 1998 – 2000

● Installed and upgraded the ORACLE Server on HP Unix server and application tools.

● Allocated system storage and planned future storage requirements for the database.

● Created primary database storage structures (tablespaces) once developers have designed an application, modified the database structure, as necessary, from information given by application developers.

● Enrolled users and maintained system security controlled and monitored user access to the database.

● Planned for backup and recovery of database information, backing and restoring the database and contacting Oracle Corporation for technical support.

● Installed and configured Oracle Enterprise Manager 1.X and 2.X Oracle Database administrator & Programmer analyst: Young & Rubicam Inc, NYC 1996 - 1998

● Installing Oracle server 8.0.3.0.0 on windows NT4.0 platform, and client development tools. Support Oracle network product SQL*Net.

● Allocated system storage and planned future storage. Enrolled and controlled users' access, and maintained system security. Planned and built instances, backup recovery planning.

● Worked with Centura language as front end and SQL Server 6.5 & Oracle8.0 as back end.

● Created reports, installed MS Sql Server 6.5 for almost all the users. Supported three systems.

● Developed test plans, test requirements and automated test suites.

● Had a close interaction with the development team.

● Regression testing, executing Automating Tests for Cross-Windows Client/Server Applications. Tracked, analyzed and reported defects (automatically generated by the SQA Test Log Viewer.

Adjunct Lecturer:

City University Of New York

● Fundamentals of Database Systems using SQL Server

● Visual Basic 4.0, Pascal and C language. Debugged logical and syntax codes.

● Organized various seminars.

EDUCATION & TRAINING

● Master’s degree in Computer Science with concentration in Software Engineering.

● Bachelor’s degree in Computer Science.

● Multiple Cloud training related Microsoft Azure and Google Platform Cloud.

● Oracle, Linux Redhat, Sun Solaris, SQL Server, Mysql, Cluster, EMC, and Six Sigma, Project Management.



Contact this candidate