Summary
Overview
Work History
Education
Skills
Websites
Technology Proficiencies
Benchmarks And Milestones
Timeline
Generic

Redwan Moin

New York,USA

Summary

Analytical strategist with a bachelor's degree in computer science and a strong history of successfully administering databases for large corporate infrastructures. Orchestrated and overseen both Production and NonProd environments, ensuring the implementation and thorough documentation of configuration, patches, upgrades, maintenance, and database migrations in strict adherence to established change management protocols. Strategic visionary, conceptual thinker, and decisive leader with strong expertise in T SQL, as well as authoring stored procedures, triggers, functions, centralized database maintenance and management. Demonstrated competence in performance tuning; risk monitoring and database security as well as HA solution such as SQL Cluster, Replication, Always-on, Mirroring and Log Shipping. Consummate communicator, with strong interpersonal skills, and the ability to liaise effectively with senior management, technical managers, and key stakeholders in support of project objectives.

Overview

15
15
years of professional experience

Work History

Database Engineer

Viking Global Investors
New York, NY
11.2018 - Current
  • As a diligent engineer at my current company, I have consistently demonstrated a strong commitment and ownership in configuring a diverse range of technologies, tailored specifically to meet the unique needs of the hedge fund business model.
  • Monitored database performance, and resolved issues to ensure stability.
  • Optimized SQL queries to enhance data retrieval performance for analysis.
  • Designed and implemented database solutions for investment data management.
  • My role involves working closely with a dedicated team of 30 developers, a collaborative effort that has significantly improved the synergy between the Database and Development teams, thereby enhancing our daily business operations.
  • An integral part of my role also involves engaging and collaborating with the company's key stakeholders.
  • I have been highly responsive to issues arising in both production and non-production environments, always prioritizing availability and reliability to ensure seamless operations.
  • Technology: The industry is very dynamic, and, as such, it requires the team to implement the highest level of technology available in the market.
  • Directly responsible for all production, development, and staging SQL Server versions ranging from 2012 to 2022.
  • Maintaining the Disaster Recovery Planning.
  • Executed data analytics to drive informed decision-making and strategic initiatives.
  • Streamlined security management protocols to enhance system integrity and protect sensitive information.
  • Automated repetitive tasks, resulting in increased efficiency and reduced human error.
  • Conducted technical troubleshooting to resolve complex issues promptly and minimize downtime.
  • Ensured regulatory compliance through thorough audits and adherence to established guidelines.
  • Optimized performance tuning processes to improve system responsiveness and user experience.
  • Managed production operations, focusing on quality control and timely delivery of outputs.
  • Facilitated cross-team collaboration to foster innovation and improve project outcomes.
  • Cloud technology is the highest standard, with database monitoring, as well as tracking changes through GIT or the CI/CD pipeline, Octopus, and Flyway for both on-prem and cloud infrastructure.
  • Cross-Functional Teamwork: Configured the Production Support (PS) environment to further assist teams like BI, Development, .NET, Data teams, etc. To test deployments before being deployed into production and/or troubleshoot issues encountered in production, being the counterpart.
  • Worked with management and developers to advise on database system design and best practices.
  • Effectively synchronize the data available in Production with Non-prod for other teams.
  • Agility: Any issue, when highlighted, needs to be addressed at the earliest in the company due to the volatility of the industry.
  • In that essence, it is always crucial to be available or within a reasonable window.
  • Worked in an iterative and incremental manner to attain the modern development processes.
  • Enhanced automation of repetitive tasks by implementing PowerShell and Ansible solutions.

Senior Database Administrator

LSEG
New York, NY
09.2015 - 09.2018
  • Led installation, configuration, and troubleshooting of SQL Server 2005 to 2016 for BAU and project needs.
  • Introduced changes in production through submitted Proposals for Change (PFCs).
  • Collaborated with various departments to ensure timely onboarding of acquired companies into LSEG infrastructure.
  • Designed, planned, and coordinated database infrastructure delivery for LSEG projects.
  • Provided support across production, test, QA, and development environments.
  • Partnered with project management teams on development of scope and timelines.
  • Trained junior DBA team members on best practices related to database administration.
  • Configured failover clustering and Always On HA, including mirroring and log shipping in all environments.
  • Mentored junior database administrators in best practices for maintenance and troubleshooting.
  • Installed new software releases, patches and upgrades on production servers as required.
  • Performed regular maintenance activities such as index rebuilds, statistics updates.
  • Created SSIS packages for ETL operations aligned with BAU requirements.
  • Oversaw migration of ETF Rating Company into LSEG infrastructure, managing all project milestones.

Lead Database Security Analyst

Deutsche Bank
NJ
09.2014 - 07.2015
  • Spearheaded Deutsche Bank-wide production database access remediation project under MAS and US Federal Reserve oversight.
  • Conceptualized and integrated data warehouse for database access-related information.
  • Developed multiple layers of data manipulation routines to enhance data analysis.
  • Created infrastructure documentation and procedures for regulatory compliance in application management.
  • Planned and directed project efforts to meet remediation objectives efficiently.
  • Ensured successful remediation through meticulous planning and risk management strategies.
  • Responded promptly to security alerts and investigated potential breaches.
  • Analyzed threat intelligence reports to identify emerging threats and vulnerabilities.
  • Audited networks and security systems to identify vulnerabilities.
  • Monitored key performance indicators and reporting information to maintain project integrity.
  • Monitored alerts generated by intrusion detection systems to identify potential attacks against corporate networks.

SQL Server Database Administrator

Franklin Credit Management Corp
NJ
04.2014 - 09.2014
  • Oversaw SQL Server 2008, 2005, and 2000 across production, development, and test environments.
  • Utilized ETL expertise for data extraction, transformation, and loading from diverse sources.
  • Created SSIS/DTS packages to enhance data integration processes.
  • Leveraged Business Intelligence Development Studio to optimize SSIS package creation.
  • Provided consultative guidance on SQL Server High Availability solutions, including Replication and Log Shipping.
  • Executed performance monitoring and troubleshooting for SQL Server environments.
  • Managed SQL Server scripting and security standards effectively.
  • Deployed a 3-tier web application utilizing the database system as back end.

SQL Server Database Administrator

Scholastic
NY
04.2010 - 03.2014
  • Upgraded SQL Server from 2005 to 2008 R2 on Windows Server 2008 R2 Enterprise Edition.
  • Installed and configured SQL Server 2008, 2005, and 2012 across development, testing, and production environments.
  • Planned and analyzed database security patches and service packs for system upgrades.
  • Implemented various replication models based on business specifications, including Peer to Peer and Transactional.
  • Designed and created databases, tables, views, stored procedures, and triggers to enhance data management.
  • Exhibited expert knowledge of SQL Server High Availability solutions like Replication and Mirroring.

Education

Bachelor's degree -

University of London
UK
01-2008

Skills

  • Windows Server (until 2022)
  • VMware
  • Microsoft SQL Server (until 2022)
  • Snowflake
  • T-SQL
  • HTML
  • Javascript
  • SQL performance tuning
  • Database design
  • Disaster recovery planning
  • Automation scripting
  • Regulatory compliance
  • Cross-functional teamwork
  • Change management
  • Project management
  • Effective communication
  • Problem solving
  • Technical troubleshooting
  • Security management
  • Data integration
  • Replication techniques
  • SQL and databases
  • RDBMS
  • Database security
  • Data migration
  • C#net
  • VBScript
  • Standard SQL
  • Spotlight
  • SQL Sentry
  • Ansible
  • Solarwinds
  • Foglight
  • ApexSQL
  • CI/CD
  • GIT
  • Flyway
  • SQL Secure
  • Filezilla
  • Active Directory
  • Litespeed
  • WinSCP
  • ILS
  • Visual Studio
  • DBArtisan
  • Powershell
  • SSIS
  • SSRS
  • SSAS
  • SQL MON
  • Relational databases
  • Backup and recovery
  • Indexing strategies
  • Multitasking capacity
  • Task prioritization
  • SCCM
  • WSFC
  • SQL Server Database Diagram
  • Access
  • Outlook
  • SharePoint 2010
  • Remedy Ticketing System
  • JIRA
  • Ontime
  • RPM
  • Confluence

Technology Proficiencies

Windows Server 2003, Windows Server 2008, Windows Server 2012R2, Windows Server 2019, Windows XP, Windows Vista, Windows 7, Windows 10, VMware, Microsoft SQL Server 2022, Microsoft SQL Server 2019, Microsoft SQL Server 2017, Microsoft SQL Server 2016, Microsoft SQL Server 2014, Microsoft SQL Server 2012, Microsoft SQL Server 2008, Microsoft SQL Server 2008R2, Microsoft SQL Server 2005, Snowflake, T-SQL, HTML, Javascript, C#.net, VBScript, Standard SQL, Spotlight, SQL Sentry, Ansible, Foglight, ApexSQL, CI/CD, GIT, Flyway, SQL Secure, Filezilla, Active Directory, Litespeed, WinSCP, ILS, Visual Studio, Visio, MRemote, ERWIN, Powershell, SSIS, SSRS, SQL MON, SCCM, WSFC, Word, Excel, Access, Outlook, SharePoint 2010, Remedy Ticketing System, GCM Ticket Portal, JIRA, Ontime, RPM, Confluence

Benchmarks And Milestones

  • Configured, automated, and maintained a centralized server to streamline jobs, database maintenance, data capture etc.
  • Architect, built, and configured numerous SQL instances on both Standalone and Cluster.
  • Formulated maintenance plans to perform backups, maintain database integrity, index defragmentation, reorganize index, rebuild index, update the index statistics etc.
  • Implemented an array of Replication Models such as Peer to Peer, Merge, Transactional and Snapshot on basis of business specification.
  • Module HA solutions to always upkeep the business whilst adhering zero data loss.
  • Mitigate SQL performance issues using execution plans, trace, statistics, Index Tuning Wizard.
  • Implemented SQL Server new features like Always-On Availability Groups, In-Memory OLTP, Policy Based Management, Resource Governor, Performance Data Collector, Linked servers, Transparent Data Encryption (TDE), MSX and Multi Server Query on need basis.
  • Maintain and upkeep Nonprod environments with the same integrity and availability as Production to meet the end users' expectations.

Timeline

Database Engineer

Viking Global Investors
11.2018 - Current

Senior Database Administrator

LSEG
09.2015 - 09.2018

Lead Database Security Analyst

Deutsche Bank
09.2014 - 07.2015

SQL Server Database Administrator

Franklin Credit Management Corp
04.2014 - 09.2014

SQL Server Database Administrator

Scholastic
04.2010 - 03.2014

Bachelor's degree -

University of London

Similar Profiles

CREATE PROFILE
Redwan Moin