Abrahim S. Email & Phone Number

Atlanta, Ga, Us

Oakville, Ontario, Canada

• Perform database/application performance monitoring and tuning in both a development and production-support capacity • Develop and implement data administration policy, standards and models • Create visualizations, alerts, reports and dashboards using Apache Superset, Redash and Grafana • Ensure existing database systems perform well and are properly configured/maintained • Establish and maintain sound backup and recovery policies and procedures in conjunction with the system administrators • Implement and maintain database security • Create and implement plans for database growth and changes • Create and document database development and testing standards • Perform database patch management and version control • Develop the required tooling and monitoring in production • Troubleshoot poor performance of queries and produce recommendations, such as indexes, IO subsystem requirements, memory, configuration, SQL query changes Etc • Write scripts related to stored procedures, triggers, and database object • High Availability, Load Balancing, and Streaming Replication • Perform logical and physical BACKUPS using pg_dump, RESTORE, (PITR) Point in Time Recovery, • Working with Extensions; pgaudit; pg_qualstats; pg_stat_statements; pgcrypto; ltree; TimescaleDB • Automation script for installing/updating Postgresql, as well as task execution with Shell Script, Power Shell, and Python.Tech: PostgreSQL, SQL Server, Big Query, Google Cloud Spanner, Power Shell, Docker, Linux, Shell Script, Python, Git, Rest API, Google Cloud Server, data manipulation, Unit testing and Github.

Toronto, Canada Area

• Provide solutions to manager device data, voice and SMS information for efficiency, productivity, and manage costs for business. • Develop and model data solution using PostgreSQL DBMS.• Apply dimensional modeling and data Transformation Techniques as Inmon (Top-Down) and Kimball (Bottom Up, Star Schema & Snow Flakes) to data extraction and report generation.• Manage database environment, and create database objects such as tables, stored procedures, functions, index, materialized view, foreign key, and database link, among others. • Set data retention, delete policy, and denormalize data to create reports (data warehousing).• Develop data generation tools helping the technical team and stakeholders handle and interact with information from Mobile and Web application.• Implement analytic tools, and manage data information to help clients in the decision making process. Technologies: PostgreSQL DBMS, XML, Java, SQL, ETL, JSON, Java Script, Git, Rest API, Agile, Scrum, NoSQL data manipulation, MCV architecture, Ruby on Rails, Jira and Github

Toronto, Canada Area

• Work on Work Roll Tracking and Lock out-tag out (LOTO) solution to ensure safety industry procedure to the completion of maintenance on dangerous machines.• Manage SQL Server DBMS and PostgreSQL database environment;• Migrate data between database server environments.• Perform analysis of database environment and queries through Explain Plan, database trace logs, etc.• Use Server Integration Services (SSIS) for building data integration solutions and to Export and Import information;• Use the SQL Server Analysis Services (SSAS) managing data applying business dimensions and Multidimensional analysis connection on Microsoft Excel.Technologies: XML, C#, SQL Server, T-SQL, Scala, Agile, Scrum, NoSQL, MCV, S3, RDS, PostgreSQL, JSON, JScript, Android, SDLC, Git, Github, Heroku, Jira and Bitbucket.

• Worked on Commissioning project with broker incentives software, Integrated with CRM solutions and reduced operational cost of the company.• Managed projects using Waterfall and Scrum Agile to achieve overall quality and productivity.• Coordinated strategic planning meetings with stakeholders to understand business requirements as to design and model tech solutions.• Designed, modeled and developed database solutions. • Created database environment including developer with stored procedures using T-SQL and PL/SQL.• Used Server Integration Services (SSIS) extracting and transforming data for business analysis.Technologies: Toad, SQL Navigator, Java, Unix/Linux, ETL, Microsoft Project, SharePoint, Shell Script, Erwin, Remedy ARS, SDLC, MS SQL Server (OLAP and OLTP), SSIS, T-SQL, Oracle, SQL, MS Access, Excel, and HP Quality Center (Test).

• Worked on database developer team bring cutting edge solutions improving tech projects.• Used ETL on Data Transformation Services (DTS), SSIS, data loader, export tools to extract data.• Delivered real-time insights across streaming data pipelines and database replication.• Developed procedure, package, function, and trigger using T-SQL and PL/SQL.• Installed, updated and managed MSSQL and Oracle database on Windows and Linux environment.• Ensured application and database environment optimization by working on tuned queries and performing database• Worked on database automation process using PowerShell, Script Shell and database schedule.Technologies: PL/SQL, T-SQL(Transact SQL), DTS, C#, ASP, Oracle Spatial, PowerShell, Script Shell, Oracle Streams Advanced Queuing, MS SQL Server, Oracle, SSIS, Microsoft .Net Framework, Linq

Rio De Janeiro Area, Brazil

Responsible for integration projects to broadcast services. SQL Server database administrator.Creating routines in SQL for SQL Server and use of DTS (Data Transformation Services)Development of Web and broadcast services applications.Management and dissemination services, promotions and information through technological projects.

Rio De Janeiro Area, Brazil

Analysis and development of applications and tools for internal clients Petrobras to increase productivity processes, optimize and computerize tasks.Point Analysis by Function, use of essential analysis Erwin, Designer and MS Project.Using Visual Basic, VBScript, Crystal Report, ERWin, ASP, JavaScript, HTML with visual studio and home site and MS Access database, SQL Server and Oracle.

Rio De Janeiro Area, Brazil

Analysis and development of the Image Bank system with the use of advanced search process by thesaurus and preview with thumbnails and images and files on overall database and application access control system.Using Visual Basic, Crystal Report, ERWin with Oracle 7.3 database.

Rio De Janeiro Area, Brazil

Analysis and development of the SAC system (Customer care service) with interactiontechnology and OLE MAPI Control.Using Visual Basic with Ingress database.

Analysis and development of applications and tools for external customers, management courses (Word, Excel, MS Project, Access, Visual Basic), installation and maintenance of machines, installation and server configuration and network.Using Visual Basic, VBScript, database MS Access, SQL Server.

Certificate

Certificate

Postgraduate

Postgraduate

Mba

Bachelor’S Degree

Associate’S Degree