PROFESSIONAL SUMMARY:
Over 13 years Professional Working experience and understating of Logical Data Model/Physical Data Mode, Normalization and De-normalization, Data Analysis using MS Excel/Power BI,Tableau etc,UNIX shell scripting and Python, data archive/restore policies, automating various processes, users, ETL/BI tools such as Informatica, DataStage, Business Objects, SAS, and Micro Strategy, Tableau, Power BI an important part of the environment./objects/rights management, Security Management, Space Management, Backup and Recovery, Workload Management, Unix Shell and Batch Scripting
Hands on Professional working experience of Oracle 11g,12c and SQL Server Management Studio 2000/2008/2014/2019,Writing SQL SPs,Preparing Data Reports using sql queries
Day-to-day database system administration, including daily checklists, backup verification, log,review,security maintenance, performance tuning
SQL Monitoring,Troubleshooting,Maintainance,Security,Performance Tuning, SSIS, SSRS
Weekly maintenance of servers using scripts and execute those scripts via SQL job
Configuration of SQL Server merge or transaction replication, Upgrade, configure and maintain server and database monitoring software to baseline system performance and proactively identify (and remedy) potential issues.
Ongoing review and completion of trouble tickets related to the database systems Creating and monitoring Table spaces, Data files, Redo logs, objects, Database, Table space, Indexes, Synonym, Views, Directories, Sequences, Creation and Management.
Perform installation, configuration, performance tuning, optimization, backup and disaster
Creating Tables, Stored Procedures, Views, Indexes, Cursors, Triggers, User Profiles, User Defined Functions, Relational Database Models and Data Integrity in observing Business Rules, Query Optimization and performance tuning of stored procedures, functions, Dimensional Modeling, ER Modeling, Star Schema / Snowflake Schema, FACT and Dimensional tables and Operational Data Store (ODS).
Implemented database Replications in SQL Server 2008, 2014 for High Availability, DR and Reporting.
Focal Person FBR/PRAL for POS( Point Of Sale IMS) Technical assistance Web API integration, Cloud POS integration,Programming,Coding,integrate to Web API,SQL and PL/SQL Languages, Oracle Customize, Reports Development, Oracle
MS SQL Monitoring, Perform tests and evaluations regularly to ensure data security, privacy and integrity, Ensuring data integrity, data security and performance of production databases, Support the development of data loads and extracts,