• Operational experience involves working on OPTIMA ETL,C# applications & Reporting Solutions
• Technologies Used: Oracle, PLSQL, Postgres ,My SQL,SqlServer, Redhat Linux, Window 2008 server R2
• Tools Used: Toad, PL/SQL developer, Winscp, Putty, Filezilla,SQL Server.
• Solid understanding of SQL writing and shell scripting
• Have good knowledge of database management system concepts
• Quick Learner
• Team player and goal oriented
• Adaptable to volatile conditions
• Expert in handling professional services & stakeholder management
• Self-motivated, ambitious, dedicated and flexible to various assignments
• Good communication and interpersonal skills
Building database systems of high availability and quality depending on each end user’s specialized role
Designing and implementing databases in accordance with end users\' information needs and views.
Defining users and enabling data distribution to the right user, in appropriate format and in a timely manner.
Use high-speed transaction recovery techniques and backup data.
Minimise database downtime and manage parameters to provide fast query responses.
Monitor database performance, implement changes and apply new patches and versions when required.
Perform tests and evaluations regularly to ensure data security, privacy and integrity.
Working on database tuning and query tuning for fast data loading
Creation of new logical design of database for front end application.
Performing validation checks on the data before inserting that data into database.
Creating DB users and assigning them the roles and priveleges depending upon their needs.
Provide support to end users in case of any queries and problems they face.
Creating new database objects like tables, views, triggers, stored procedures etc. for C# applications.
Writing complex queries for data visualization software.
Creating SQL cursors for row wise operations.
Taking backups of the database and maintain Always on High Availability group policies.
Set up and control user profiles and access levels for each database segment to protect important data.
Assist with schema design, code review, SQL query tuning
Creating datasets for data visualization software (Tableau, BrighGauge)
Connecting the apps using Rest-APIs and Webhooks to CRM software.
Maintain data integrity and referential integrity for the data.
Updating the database tables as per requirements from the departments.
Creating SSIS package for data insertion from CSV to Database table.
Creating Tableau and Bright Gauge reports and gauges for the dashboards and users.
Integrating RestAPI with TigerPaw CRM.
Creating crystal report templates on organizational needs.
Proved successful working within tight deadlines and fast-paced atmosphere.
Created spreadsheets using Microsoft Excel for daily, weekly and monthly reporting.
Conducted research, gathered information from multiple sources and presented results.
Creating and implementing database designs and data models.
Testing programs and databases to identify issues and make necessary modifications.
Set up and control user profiles and access levels for each database segment toprotect important data.
Coordinate with project management staff on database development timelines and project scope.
Managing systems and infrastructures by defining hardware requirements andplanning storage capacity for database.
Administer, support and monitor databases by proactively resolving database issues and maintaining servers.
Writing and maintaining technical and functional specifications to document database intentions and requirements.
Install, upgrade, configure and tune database and all associated middle-warein LINUX and Windows environments.
Build databases and table structures following CRM architecture methodology for web applications.
Handling queries as per agreed SLA to address customer inquiries and concerns.
Proactively evaluating mediation & database health and performance on dailybasis .
Delivery:
Deployment of OPTIMA OSS ensuring smooth Delivery & Acceptance of projects
Installation and configuration of Oracle Databases and associated data models
Integration of Optima ETL solution with multi-vendor platforms
Implementation of customized KPIs, reports, modules and alarms
Formulation, Testing & Harmonization of KPI’s across the network
Delivering Proof of Concept for products in conjunction with sales/pre-sales for customers
Support:
Providing Technical Support to customers and ensuring resolution of faults within given SLA
Proactively evaluating mediation & database health and performance on daily basis and providing 24*7 on call support for best customer experience.
Daily monitoring of ETL processes to ensure data quality and completeness
Managing customer requests (ad-hoc reporting/data unavailability) within agreed SLA
Assisting End Users by providing solution and permanent fixtures of issues logged