https://dream.weekday.works/redirectToHiringCopilotExtension/

•	Leads the planning, analysis, design, implementation, maintenance, and control of the organization’s server-class databases.
•	Team / Shift Management, Work Distribution & SLA Management.
•	Daily Client Reporting.
•	Weekly review presentation to client.
•	Process Management & Knowledge Transfer.
•	System Monitoring, addressing Alerts and Routine DBA tasks. 
•	Review of performance recommendations.
•	Involved in requirements gathering and data gathering to support developers in handling the design specification.
•	Extensive experience in writing and executing scripts for validation and testing of the sessions, data integrity between source and target database and for report generation.
•	Involved in loading of data into Teradata from legacy systems and flat files using complex scripts.
•	Created Teradata External loader connections such as MLoad, Upsert and Update, Fastload while loading data into the target tables in Teradata Database.
•	Involved in understanding Business and data needs and analyze multiple data sources and document data mapping to meet those needs.
•	The mappings involved extensive use of transformations like Aggregate, Filter, Join, Expression, Lookup, Update Strategy, Expressions, Sequence Generator Transformations.  
•	Performance tuned the workflows by identifying the bottlenecks in targets, sources, mappings, sessions and workflows and eliminated them.
•	Prepared Unit Test Specification Requirements.

Sierra Ventures

Advanced Technology Ventures

Stifel

Cove Capital

Cloud based platform offering big data analytic engine and customer data. It provides a platform for analytics data, marketing, analytic applications, and consulting solutions. It provides a database to deliver real time results. It provides a data manager that unifies the data about customers, suppliers, distributors, products, and locations. It also provides real time integration and synchronization of a single view of data.

Cloud based platform offering big data analytic engine and customer data

•	Working on developing best practices for Database performance optimization.
•	Leads the planning, analysis, design, implementation, maintenance, and control of the organization’s server-class databases.
•	System Monitoring, addressing Alerts and Routine DBA tasks. 
•	Review of performance recommendations.
•	Suggested MVC implementations which resulted in huge savings of disk space, IO and CPU.
•	Performance tuned the workflows by identifying the bottlenecks in targets, sources, mappings, sessions and workflows and eliminated them.

•	Created Macros as per requirements.
•	Handling Adhoc requests as a Development DBA.
•	Operation activities include daily proactive tasks in DEV and QA systems.
•	Handling Pre and Post Implementation activities during major releases.
•	Attending Weekly DBA call for any technical discussion/new process addition/change.
•	Documented Runbook and Conversion sheet from SQL to TD.
•	Monitoring and Noting down technical issues and bringing them in Weekly DBA call.
•	Solving ad hoc requests for access rights, query tuning, space management, Lock release etc. as per the user requirement.
•	Tracking Capacity requirement before any production implementation and ensuring estimated space availability, in order to ensure smooth loads after production Implementation.
•	Executing change requests for DDL & DML statements from the users.
•	PPI Maintenance activity on all Servers.
•	Periodically cleaning obsolete objects for space management.
•	PI Analysis of Skewed Tables for Space saving.
•	Attended SIT/UAT/Production Implementation Review meetings with development teams for different projects.
•	Performed SDLC migration.
•	Provided Development DBA support on weekends for production Implementation activity.
•	Implementations in SIT/UAT, IR and PROD environments.
•	Having Architectural review meeting for upcoming projects.
•	Role alignment on DEV & QA systems.
•	Creating / aligning of role according to the business needs.
•	According to developer’s need, created and Implemented (TDDEV, TDQA and TDPROD) STATS REFRESH procedure, which was supposed to be done by Development DBA Team manually.
•	Performing DDL check process and make sure that it should follow Standards.

•	Creating Test and Development environments and granting access/privileges based on requirement without impacting the Security policies.
•	Performing Data copy jobs to maintain enough data in the SIT and UAT region for proper testing of codes.
•	Solving ad hoc requests for data backup, query tuning, space management etc. as per the user requirement.
•	Worked on Code Review by using Teradata Statistics wizard.
•	Worked on DDL QA Check Process to find out any discrepancy available in DDLs Generated.
•	Performing /Setting up Process like DDL generation/ QA checks. 
•	Knowledge and worked on Backup and Recovery on TARA Server.
•	Worked on giving Access Rights to users on Insert and Select on Database and also used Teradata Administrator for finding out different Rights held by the user..
•	Worked on Stats Collection request given by the client team.
•	Worked on Release Data Copy through T10 process.
•	Created Proxy id’s for the users.
•	PC skills in Windows NT & 2000 environment with Microsoft Office Products, MS Word, MS Excel, Outlook & Teradata ODBC client tools. 
•	Performing /Setting up Process like DDL generation/ QA checks. 
•	Handling/Setting up Process for Migration/Implementation activity.
•	Handling the weekly and Daily calls with client and Development teams.
•	Periodically cleaning up obsolete Objects from Databases by coordinating with concerned Teams.

•	Worked in Backup and Recovery in SQL server 2000, 2005, 2008.
•	Worked on Database Mirroring.
•	Done Replication on IBM Infosphere Datastage tool.
•	Creating and Monitoring log shipping.
•	Done Windows & SQL Server Clustering on VMWARE Workstation.
•	Creating Linked Servers.
•	Shrinking of Log files and Database in SQL.
•	Importing & uploading files from different remote locations, Preparing Reports
•	Performance monitoring & Tunings using SQL Profiler.
•	Create new query and run Store Procedure.
•	Run SSIS Packages.
•	Worked on tool RedGate for SQL server Backup and Restoration Databases.
•	Run Service packs.
•	Data requirement or report generation as per client’s requirement.
•	Installing SQL server 2000, 2005 and 2008.
•	Worked on IBM WAS Administrator.
•	Worked on IBM Infosphere Server (DATASTAGE) at Level 1 Support.
•	Worked as DB2 Database Administrator at Level 1 Support.
•	Checking Backup and Log Backup on production servers.
•	Worked on Database Mirroring.

Incorporated in 2002, MindCraft provides Software Solutions and Services to large Indian and Multinational customers. We help our customers get competitive edge through technology services that include Development & Integration, Business Intelligence and Systems Software Management.

Industry Vertical Focus: Banking, Life Insurance, Mutual Funds, Financial Services (BFSI) and Pharmaceuticals.

Technology Services:
Digital Transformation Services - Digital Application Development, Microservices Development & Containerization, Service-oriented Architecture & API, BPM & Robotic Process Automation, Business Rules Management
Business Insights - Reporting & Dashboards, Data Marts & Data Lakes, Operational Data Stores, Extract, Transform, Load (ETL), Visualization
DevOps - CI / CD Configuration, Release Management, Code Review & Code Coverage, Configuration Management, Infrastructure as Code, Docker Build & Management
Cloud Services - Cloud Migration, Cloud Foundry, Private Cloud, Cloud Infrastructure Management (AWS, IBM Bluemix, Google Cloud)
Middleware Services - IBM Middleware, Oracle Middleware, Red Hat Middleware

Technology Focus:
Development - Java based on IBM and Oracle Platforms
Business Intelligence - BO, OBIEE, Cognos, SSRS/SSAS
Infrastructure - IBM, Oracle Middleware Platforms and Databases

Major Alliances: IBM, Microsoft, Solace Systems

Footprint: India, Singapore, USA

Websites:
India - https://www.mindcraft.in 
USA - https://www.mindcraftamerica.com 
Singapore - https://www.mindcraft.com.sg

Kotak Securities is one of the oldest and trusted equity brokerages in India, established in 1994. As a subsidiary of Kotak Mahindra Bank Ltd., we provide our customers with opportunities in the capital markets, smart technology, and useful insights to make successful investments. 
Our dedicated in-house research division publishes various sector and company-specific studies that offer analysis of stocks, helping investors to make informed decisions.

As a growing firm, we constantly strive to innovate our technology platforms and give the best of services which include the following:

1) Trade Free Youth for under 30 years encourages youth to get a better hand in the market by saving brokerage across all segments.

2) On the other end, for people above 30 years, our Trade Free Plan gives additional benefits on trading like saving brokerage on certain segments. Know more about the plan - https://bit.ly/TradeFreeWithKotakSec 

For more details visit us at www.kotaksecurities.com

Disclaimer: http://bit.ly/29QEqJf