Sujay Kumar Singh

Experience

• 

  JuxtConsult Research and Advisor Pvt. Ltd New Delhi

  Jul 2008 - Nov 2009

  Database Administrator

  JCR is a global Internet information provider to which leading companies turn for consumer behavior insight that drives successful marketing, sales and trading strategies. My job is to support the fast-growing JCR survey business. Install and configure server software and hardware for Development, Test and Production environments. Working as a team member with other DBA’s ensure 365 * 24 * 7 day a year support to all databases In JCR have design and implement 30+ databases over 500 GB database size in Production environments. o Managed the migration of SQL Server 2000 databases to SQL Server 2005. Define and enforce database standards, policies, security and documentation. o Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS. o Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.o Developed, Performance and optimized database structures, stored procedures, views, triggers and user-defined functions...o Troubleshoot system issues, monitored scheduled jobs and set up maintenance plans for proactively monitoring the performance of SQL Server databases.o Managed the products and development databases including performance tuning, capacity planning, SQL Server clustering, database security configuration, and database continuityo Creating users and maintaining system security. Controlling and monitoring user access to the database. Optimizing the performance of the database and creating database exports.Environment: SQL Server 2000/2005 Enterprise Edition, Windows Enterprise Server 2003, Microsoft Reporting Service. Show less

• 

  Fujitsu

  Nov 2010 - Jan 2012

  Technical Analyst

  Fujitsu delivers world-wide Maintenance and Support Services for heterogeneous infrastructures out of one hand: From integrating new technologies in IT infrastructure to providing fast and uncomplicated support proactively. My job responsibility to manage the teams and provides the 24*7 support as per client requirements. o Interact with US, UK, Germany and Middle East clients.o Onside work experience in Middle East Region (ORYX GTL Project).o Managing the DB team and assign the work according to the project requirement.o Designing and documentation of DC and DR data Center and backup policies at all servers.o Designing and implemented the reporting option in production server.o Using profile and DMV for monitoring the database activities and tune Query.o Managed the products and development databases including performance tuning, capacity planning, SQL Server clustering, database security configuration, and database continuity.o Provide multi-node cluster server, load balancing and reporting server configuration server to the clients.o Troubleshoot system issues, monitored scheduled jobs and set up maintenance plans for proactively monitoring the performance of SQL Server databases. Show less

• 

  NIIT Technologies Limited

  Jan 2012 - Dec 2012

  Database Analyst

  EISEI (NASDAQ: SEIC) is a leading global provider of asset management, investment processing, and investment operations solutions for institutional and personal wealth management. We help private banks, investment advisors, investment managers, institutional investors and affluent individuals create and manage wealth.SEI offers solutions for:• Private banks and trust institutions -- Comprehensive solutions for every facet of a wealth management business, including investment management, investment processing, infrastructure operation and business development. • Financial advisors -- Wealth management platforms for independent investment advisors, including end-to-end solutions for practice management, investment management and investment processing. • Institutional investors -- Retirement and Manager-of-Manager investment programs for corporations, healthcare organizations, multi-employers, municipalities, foundations, endowments, and other institutional investors. • Investment managers -- Asset administration and investment operations outsourcing solutions for managers of mutual funds, hedge funds, private equity funds, and separately managed account programs. Show less

• 

  Wipro

  Jan 2013 - Sept 2016

  Technical Lead

  Wipro helps customers to do business better leveraging our industry-wide experience, deep technology expertise, comprehensive portfolio of services and a vertically aligned business model. Our 55+ dedicated emerging technologies ‘Centers of Excellence’ enable us to harness the latest technology for delivering business capability to our clients. My job responsibility to manage the teams and provides the 24*7 support as per client requirements. oOperating 24*7 support team for ANZ client for build server, test server and production servers.oManaging the team (perform L3 and L4 support by senior member) and assign the work to team. Handling TB of database in ANZ including all kinds of production issue.oDesigning and documentation of DC and DR data Center and backup policies at all servers.oInvolving Production, release and Implementation activities.oDesigning and implemented the reporting option in production server.oBuild High availability solution (logshipping, Clustering, Database Mirroring and Replication) for ANZ banking clients.oUsing profile, DMV and perfmon for monitoring the database activities and tune Query.oManaged the products and development databases including performance tuning, capacity planning, SQL Server clustering, database security configuration, and database continuity.oProvide multi-node cluster server, load balancing and reporting server configuration server to the clients.oTroubleshoot system issues, monitored scheduled jobs and set up maintenance plans for proactively monitoring the performance of SQL Server databases. Show less

• 

  Sungard Availability Services

  Oct 2016 - Feb 2017

  Technology Expert

  As a SME my responsibility to ensure the facts and details are correct so that the project’s deliverable(s) will meet the needs of the stakeholders, legislation, policies, standards, and best practices. To achieve this, SMEs will:-Define procedures or standards, since he/she has the knowledge of what the right or best way to execute a task would be-Define performance objectives, and determine acceptable performance levels-Provide recommendations for procedural improvements-Understand the language/terms/jargon in his/her area of expertise-Understand requisite knowledge that underlies effective decision-making and is able to describe where anomalies or flaws may occur in the decision-making for his/her area of expertise-Act as the “go to” person within a department or function for questions and problems within his/her area of expertise-Explain his/her area of expertise clearly to others-Not only answer how things are done, but why-Support the definition of processes and policies, supply business rules and procedures, and communicate the contexts in which the rules, processes and polices are applied-Accurately represent their business units’ needs to the project team-Validate the requirements and deliverables that describe the product or service that the project will produce-Bring information about the project back to the customer community-Provide input for the design and construction of test cases and scenarios, and may also validate executed test results-Provide input into and/or create and execute user documentation and training material-Test the product or service towards the end of the project (User Acceptance Testing), using and evaluating it for accuracy and usability, providing feedback to the Project Team-Guide other professionals on the project to ensure the content is accurate-Resolve issues relevant to project deliverable(s) within their area of expertise-Obtain or provide approval for changes to rules, processes and policies Show less

• 

  Cognizant

  Feb 2017 - Mar 2022

  Subject Matter Expert (Technical Manager)

  A dynamic, SME, Lead, team spirited and performance driven MCDBA, MCITP, MCTS, Azure, ITIL certified professional offering 15+ years of extensive experience that includes leading team of DBA’s, people management, database administration, trainer, database design, development and support of MSSQL 2008/2010/2012/2014/2016 in production, Model, Test and development environment including 5+ years of relevant Azure Database and Cloud experience.

• 

  HCLTech

  Apr 2022 - now

  Consultant

  * Database Administration * Database Management * Data Warehousing * Data Migration * Migration to Cloud* System Management * Infrastructure Management * Cloud Management * Process Automation *