Description
SUMMARY * Senior Database Analyst /Administration, Team Lead and Database Architect in MS SQL Server, Sybase environments. Having 10 years of Hedge fund, 3 years in financial industry experience and various blue-chip companies like Sharp Electronics, Verizon, Blue Cross Blue shield, Elpaso energy and international experience. Delivering IT services to the business team and helping on the decision making Alternative Investment Services, Fixed income & Equity Derivatives team. Dynamic Infrastructure Monitoring & Data center migration, strong financial management. Good leader, Team player with excellent communications skills. Very good experience development, design and Release Management system. Experience in conducting structural walkthroughs, working (liaison) with senior management, department heads, users and IT team to conceptualize the database features and to understand the business needs. Involved in 24x7 production support whenever required. Database design, architect, Backup, Recovery, Performance tuning, Table/Index partitioning. Server Consolidation, Capacity Planning. Implementation of SAS 70 & SOX audit/Compliance procedures. * Hands on technical experience (current) with MS SQL Server 2016/2014/ /2008 R2, Sybase IQ, Sybase 15/11.3, DB2 and Oracle 12c. Extensively used Idera Sql compliance, Ignite, Embarcadero DBA Artisan 5.1, Change Manager 5.1, CommVault, Tidal, DPA from Solarwinds. Solid experience in Windows 2008 R2 / 2003 /2012/ NT 4.0, UNIX, Sun Solaris operating systems. Working with Charles River, Sophis FSS, Risk metrics and Actimize vendor applications. Moore Capital 2007 - Current As a SQL Server DBA/Architect - Team Lead in Moore, supporting over 75 SQL servers, 5 Oracle servers and 15 Sybase servers for various financial trading applications. Primarily supporting for Trading, Risk applications, reporting and data warehouse applications. Additionally communicate project areas such as task prioritization, budget, schedules and software licensing. Liaison with the Application team, business analysts to design, develop, implement, resolve and report on issues, produce metrics and trending as required. Responsibilities: Provide leadership role to implement infrastructure best practices and mentoring the team on SQL Server tools, SAP IQ & Techniques * 24/7 Production Server Support and resolve Sev1/Sev2 tickets in a timely fashion and provide status to Senior Management professionals. * Implement controls, policies, processes and best practices in the database admin area. * Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security. * Expert level of SQL Server RDBMS installation/configuration, patching, troubleshooting, performance tracking/tuning, back-up/recovery, remote monitoring skills with hands-on experience in -large and very dynamic environments. * Performed SAP IQ, Oracle 11g and 12c database administration tasks in Linux OS. Extensively used Tidal as a schedule management software. * Strong DR experience (design, implementations and plans). Hands on skills in setting up and managing Always-On Availability Groups, Clustering, Mirroring, Replication. * Develop and maintain policies and standards focused to maximize effectiveness and minimize costs related to the acquisition, implementation and operation of IT systems. Maintain a rigorous SAS audit compliance control environment. Provide leadership and execution for multiple long-range projects and day-to-day production operations. * Implemented Resource Governor, Change Data Capture (CDC), SSIS package implementation & deployment best practices, Table Partition for very large tables. * Identify automation opportunities and implement solutions to improve efficiency, service reliability and productivity. Data Warehouse Architect role in Design, develop, deploy MS Analysis Services. * Automate Change control deployments and repeated tasks to meet & exceed the SLA * Successfully execute multiple projects, track and report progress and work with several project managers, business partners and cross functional teams to develop an integrated framework. * Design, develop, monitor, and performance tune data warehouse tables, views, indexes, stored procedures, service broker components, etc. on a SQL Server 2016/2014/2008 R2 Enterprise Edition environments. * Hands On experience in implementing the best practices in VM, 3 PAR / NetApp SAN storage environments. Involved in conversion of Egenera physical blade to VM using P2V and migration to 3PAR storage from Netapp storage system Alliance Bernstein 2004 - 2007 As a SQL Server DBA Team Lead in Alliance Bernstein, supporting over 300 SQL servers for various applications. Managing a team of 8 Sql server DBAs in outsourcing center - India. Primarily supporting for Global analytics, Product Development, Cost Allocation and budgeting, Corporate Finance, Cognos Report net, and Hyperion, Remedy, Private Client, Global Equity, Mutual fund Technologies and Fixed Income applications. Additionally supporting some of the Sybase applications database. Responsibilities: * Communicate effectively to the team and identify opportunities to improve the availability, performance of an application. Present effectively to the senior management, internal and external clients. Interact with the internal clients management, vendors and other infrastructure teams to ensure that the correct solutions are implemented and that business needs are met on timely basis. Identify gaps in the infrastructure, application monitoring and gaps in operating procedures. Track improvements over performance and availability baselines. * Responsible for 24/ 7 Production Server Support for the Global Support model. * Experience in Project Management, a deep understanding of systems development processes, as well as deep technical knowledge. * Perform data mapping and develop data definitions based on functional requirements. * Set up, trouble shoots and optimizes Transactional and Merge replication. * Very proficient in using the Performance Monitor, SQL Profiler, SQL Debugger, Index wizard, SQL Lite speed, Lumigent and DTS. * Perform Database security tasks based on SOX Audit procedures. * Create Support batch and real time processes and data feeds for a fixed income trading / portfolio management system. * Proactively communicate project areas such as task prioritization, budget, schedules, backup and recovery, and performance optimization. * Responsible for assembling the project team, identifying appropriate resources needed, develop and execute the project plan, and assign individual responsibilities. Function as a team builder for the Server consolidation/migration project. Coordinate across various functional Information Management areas to provide feedback and resolve issues. Worked on various data center, server consolidation, capacity planning and completed new projects on-time.
Accomplishments
Highlights:
Keywords
