Shabnam Singh

Experience

• 

  City of New York, Recycling

  Jan 1989 - May 1990

  Programmer

  Programmer analyst, installation, support PC workstatations/networks. Evaluate purchase hardware/software.

• 

  Bankers Trust

  May 1990 - Feb 1991

  Senior Programmer

  Provided specialized software and hardware expertise. Solved PC related user problems. Recommendec and purchased hardware and software solutions for users.

• 

  Edward Blank Associates

  Apr 1991 - Jun 1993

  Programmer

  Programmer analyst, VAX/VMS

• 

  Edward Blank Assoc Inc

  Apr 1991 - Jun 1993

  Programmer Analyst

  Programmed in C under a VMS environment

• 

  Leake and Watts Services, Inc.

  Jun 1993 - Sept 1996

  Database Administrator
• 

  Empire Blue Cross Blue Shield

  Sept 1996 - Dec 1997

  Senior Programmer Analyst

  SQL Server Database Administrator and Visual Basic programmer

• 

  TradeWeb

  Jan 1998 - Apr 2013

  Vice President

  Supported over 100 SQL servers in a highly active trading environment. Supported transactional replication, merge replication globally, for warm standby and reporting purposes across domains and firewalls. Planned, documented and participated in disaster recovery/business continuity procedures for enterprise wide databases. Monitored and maintained databases in a heavily replicated environment (merge, transactional) globally. Set up replication across firewalls and different domains. Planned, tested and coordinated and applied service packs in a clustered environment. Installed, configured and supported SQL Server 2008 Analysis Services and Reporting Services. Planned, coordinated and executed upgrades for SQL server from 6.5 to 7, 7 to 2000, 2000 to 2005 and 2005 to 2008 of over 80 SQL servers without any issues. Planned, coordinated and participated in moving of data centers.Conceptualized, designed, implemented, monitored and supported enterprise wide fixed income securities management and related projects. Worked with product managers and developers to analyzed specifications for various fixed income instrument types (Treasuries, MBS, Agencies, Commercial paper, Corporate Bonds, Euro Sovereigns, Canadian bonds, IRS, CDS etc.) Designed, coded and maintained fixed income securities database (architecture, data modeling, automating maintenance using stored procedures). Analyzed requirements, designed and coded Transact SQL scripts/stored procedures for importing securities (Mergent, S&P, Markit, Datascope) from third party vendors using Perl and SQL. Automated addition of new securities/maintenance of existing securities through SQL scripts/Stored procedures/ SQL jobs in the securities database. Automated and maintained ETL processes for the securities data. Show less

• 

  Intercontinental Exchange

  Apr 2013 - Apr 2015

  Senior Database Adminstrator/Developer

  Spearheaded project to migrate SQL Server 2008r2 database to Oracle 12c. Full project life cycle from installing and learning Oracle, conceptualizing, planning, designing, deploying, testing and troubleshooting the migrated SQL Server database objects to Oracle. The database contained over 700 stored procedures, 200 tables, triggers, all data types including timestamp, GUIDS, identity columns, xml type, computed columns, temporary tables, table variables, functions returning tables etc. Analyzed, documented, and found and deployed solutions for existing data issues in the database.Supported and maintained in production, development, and QA SQL Server database environments. Set up, maintained, monitored and documented database maintenance jobs, backup, recovery and business continuity procedures. Planned, set up, tested and documented log shipping and reverse log shipping. Participated in business continuity testing at ICE. Set up alerts to monitor deadlocks, blocked processes and send details of offending queries via email. Supported releases through moving changes from testing environments to production. Monitored, identified and fixed slow running queries. Show less

• 

  Convergex

  Jul 2015 - Jul 2018

  Senior SQL Database Administrator/AWS Cloud Architect

  AWS Solutions Architect/DBACreated LAB SQL domain AWS, consisting of 5 AWS EC2 instances with SQL Server 2016, 2017 and SQL 2017 for Linux, for testing functionality and features. Setup up domain controller, create domain, set up DNS etc. for a fully functional SQL Server test environment in the cloud. Installing and testing SQL Server running in Docker containers for Windows and Linux. Coding Python scripts using boto3 to access and manage AWS resources.Writing Python script using RESTful API to move files to S3 buckets.Evaluated, created Amazon Athena POC for querying archived data. This involved spinning off an EMR cluster with Hadoop with an AWS Data driven pipeline to transform the data and write to S3 storage in Parquet format. Worked on data lake project writing csv files in parquet format to s3 buckets using Python for querying using Athena for data lake project. Also configured Apache drill to query data from multiple data sources S3 parquet files, csv, and SQL Server. Installed and configured ODBC driver for Athena to be accessed for querying Athena data lake via SQL Server linked server.Planning, coding and testing PowerShell scripts for migrating SQL Servers to AWS EC2. Scripts extracted logins, linked servers, automated mirroring setup, backup and restore from source to destination servers.Using Chef resources and Ruby to write SQL server migration cookbook that applied migration scripts written in SQL to automate deployment of on premise server, restoring databases, adding logins, configuration, jobs and linked servers to AWS.Migrating Oracle 11g data to PostgreSQL RDS instance. Using AWS schema conversion tool and Data Migration service. Creating instances, planning implementing, testing. Writing python script to verify row counts. Troubleshooting, installing linked server for direct query access to AWS Athena database with the Simba ODBC driver for Athena. Show less

• 

  ACA Compliance Group

  Sept 2018 - Jun 2019

  Senior SQL Database Administrator/AWS Cloud Architect

  SQL Server Migration, upgrades, consolidation in AWS

• 

  CONSOLIDATED EDISON

  Sept 2019 - Jun 2020

  Senior SQL Database Administrator/AWS Cloud Architect

  SQL Server upgrade, migration to cloud

• 

  NEW YORK CITY HEALTH AND HOSPITALS CORPORATION

  Jul 2020 - Aug 2021

  Data Warehouse Engineer Cloud Architect

  Datawarehouse Project on Snowflake

• 

  BNY Mellon

  Aug 2021 - now

  VP