CJ Reddy [US Citizen]

adxiwi@r.postjobfree.com

SUMMARY:

• 14+ years of IT experience in Administration and Development on Database Design using SQL server 2008, 2012, 2014, 2016 and 2019 Servers in OLAP and OLTP environment systems along with experience in Business Intelligence development, Data Modeling and Analytics in different fields like Finance, and Healthcare.

• Excellent SQL Server administration skills including Database Creation, Tables, Indexes and Clusters Creation.

• High level understanding of RDBMS concepts as well as Data Modeling and Azure SQL concepts.

• Sufficient hands-on experience in HA DR High Availability Disaster Recovery techniques like Log Shipping, Mirroring High safety High performance, Replication Snapshot Transactional and Clustering Active - Passive and Active- Active.

• Experience working with data-tier application DAC for Migration & Experience in Migrating SQL Servers 2008/2008R2/2012/2014, 2016 and 2019. Furthermore, extensive use of DTS in SQL Server, Performance Tuning & Application Design, Disaster Recovery Planning, Security Management, Managing server and clients. Also, supported teams in resolving SQL Server Reporting services and T-SQL related issues.

• Excellent experience in implementation of TLS/SSL Security Implementation.

• Experience is providing 24X7 on call support and experience in SQL Server 2008 concepts SSIS (SQL Server Integration Services), SSAS (Analysis Services) and SSRS (Reporting Services).

• Experience in supporting dozens of Amazon AWS implementations including Amazon EC2 (IaaS) and all Amazon RDS (DBaaS)Amazon AWS services include provisioning, implementation, Administration and monitoring support for Microsoft SQL Server, Very strong in Amazon AWS provisioning, administration, monitoring and troubleshooting.

Experience in data migrations, backup and recovery, geographic data replication (Region and Availability Zones), CloudWatch performance monitoring,

System tuning and disaster recovery configuration and execution

• Experience in using third party tools for Data modeling SQL Diagrams, Erwin, for Backup Solutions SQL Lite Speed, for performance Fog light and for alerting Idera.

• Strong interpersonal skills, with the ability to easily and effectively interact with technical, non-technical, and business staff at all levels.

SKILLS:

• Operating Systems: Windows Server 2019, 2016, 2012 and 2008 Professional/Vista/7, MS DOS.

• Databases: MS SQL Server 2019, 2016,2014,2012 and 2008 MS Office Access.

• Programming: HTML, XML, C++, Java, JavaScript. Python Service, Genesis 2.0,

• Applications: Microsoft Office, Microsoft Visio, Microsoft Publisher, Microsoft Project, Share Point; Setting up Log Shipping & using DTS (Data Transformation Service); Administration and Installing of MS SQL Server 2019, 2016 2014,2012 and 2008,

• SQL Server: Management Studio, Business Intelligence Development Studio, Visual Studio 2005, Enterprise Manager, Query Analyzer, Profiler, Performance Monitor, SQL, T-SQL, DDL, DML, Stored Procedures, UDF, Triggers, OSQL, DTS, Log Shipping, Server Network Utility, Database Tuning Wizard, Index Tuning Wizard, SSIS, Microsoft Clustering Services (MSCS).

• Report Tools: MS Reporting Services (SSRS), Crystal reports.

• Data migration: MS DTS, SSIS, BCP, Data Migration, SQL Loader, Import/Export Wizard.

• Others: ER-Win v 4.0, Visio 5.0, PL/SQL, Visual Source Safe, Net Backup, Compaq Insight Manager, Idera Diagnostic Manager, NetIQ, Quest Spotlight, SQL Light speed, ERWIN 4.0, Toad, SQL*Plus. MSSQL Server Skills:

• SQL DR implementation using Always On availability, Replication techniques, DB Mirroring & Log Shipping and.

• SSIS, SSAS, SSRS & BIDS (Business Intelligence Development Studio).

• Implementing best practices for dedicated SQL Server's.

• Performance tuning & Query Optimization.

• Upgradation & Migration Wizard for MSSQL 2019, 2016,2014, 2012 and 2008.

• Database Maintenance and Creating Job and Alert. Rapiddb

• Experience in supporting AWS implementations including Amazon EC2 EXPERIENCE

Investors Bank\Citizens Bank, NJ July 2019 to Current Sr. SQL Server Database Engineer

Responsible for providing database administration of SQL Server databases and mentoring provided strategic direction for the database team and functioned as the technical/project leader on projects.

•Managed and administered 2800+ database in 105 instances. Initiated a project to consolidate servers and to remove old/unused databases. Reduced the number of databases to under 900 on 177 instances. configured a SQL 2019, 2016 and 2012 clustered environment with availability groups. Installed. Documented processes for installations, clustering, availability group setup, and patching. remediation of MS SQL 2019, 2016, 2014, 2012 and 2008, (SQL Engine, SSRS, SSIS).

•Implementation - Effectively manage half projects at the same time. These ranged from new implementations to upgrades. Project DBA and cover all issues. Very comfortable and familiar with process. Many of these where none standard and required being a full design partner. Control over the installation of MS SQL Server packages and Ability to patch MS SQL Server Clusters. Experience working with Azure SQL Database Import and Export Service. Deploying SQL Databases Administration - Manage several applications comfortable with Maximo and the change management process. Setup maintenance plans. Comfortable migrating data from multiple sources, SSRS reports and SSIS packages. Help business partners create scripts to massage data in their ETL process.

•Provide regular updates on database health to stakeholders. Work with reporting and development teams to tune SQL queries. Manage backup/recovery for SQL Server instances. Performs problem resolution and root cause analysis along with recommending and implementing preventive techniques. Develop in-depth knowledge of business processes facilitated by our software products, Understands principles of database physical and logic design. Monitor the performance of the scheduled jobs and alerts

•Migrate data from different sources including flat files, MS Access, Oracle 11i/ to SQL Server 2008 by using SSIS. Install multiple clients and resolved 32/64-bit driver issues, Microsoft SQL Server 2019,2016, 2014 and 2012 and Windows 2012/2016.

•Comfortable coding T-SQL.

•Develop in-depth knowledge of our software products. Keep abreast of the changing market for information services and tools. Valkyrie Setups / Configurations servers,

•SSRS\SSIS Automations for DR Deployment Scripts / Configurations of Existing SSRS Systems (ENVENTORY) Auto- sys client configurations on SSIS Server pointing to development Servers. AmeriHealth Caritas PA Nov 2018 to Jun 2019

Sr. SQL Server Database Engineer

Responsible for providing database administration of SQL Server databases and mentoring provided strategic direction for the database team and functioned as the technical/project leader on projects.

•Managed and administered 2800+ database in 105 instances. Initiated a project to consolidate servers and to remove old/unused databases. Reduced the number of databases to under 900 on 56 instances.

•Installed and configured a SQL 2016, 2014 and 2012 clustered environment with availability groups. Installed and configured a SQL 2008 clustered test environment.

•Configured and supported replication and log shipping in both SQL Server 2012, 2014, 2016 and 2019.Documented processes for installations, clustering, availability group setup, and patching. remediation of MS SQL Server 2019,2016, 2014 and 2012, (SQL Engine, SSRS, SSIS).

•Implementation - Effectively manage half projects at the same time. These ranged from new implementations to upgrades. Project DBA and cover all issues. Very comfortable and familiar with process. Many of these where none standard and required being a full design partner. Control over the installation of MS SQL Server packages and Ability to patch MS SQL Server Clusters. Experience working with Azure SQL Database Import and Export Service. Deploying SQL Databases in AZURE. Provided cloud computing services in IaaS and various other cloud services

•Administration - Manage several applications as they transitioned to BAU. Several, because of their short life cycle, never left portfolio, Changes to packages to allow SP installation.

•Comfortable with Maximo and the change management process. Setup maintenance plans. Comfortable migrating data from multiple sources, SSRS reports and SSIS packages. Help business partners create scripts to massage data in their ETL process.

JP Morgan Chase Delaware March 2018 – Nov 2018

Sr. SQL Server Database Engineer

• Expertise in implementation, administration, troubleshooting and remediation of MS SQL Server 2019, 2016, 2014, 2012 and 2008 and MS SQL 2005 (SQL Engine, SSRS, SSIS).

• Implementation - Effectively manage half projects at the same time. These ranged from new implementations to upgrades. Project DBA and cover all issues through BAU. Very comfortable and familiar with JPMC Project process. Many of these where none standard and required being a full design partner. Control over the installation of MS SQL Server packages and Ability to patch MS SQL Server Clusters.

• Experience working with Azure SQL Database Import and Export Service. Deploying SQL Databases in AZURE. Provided cloud computing services in IaaS and various other cloud services

• Administration - Manage several applications as they transitioned to BAU. Several, because of their short life cycle, never left portfolio, Changes to packages to allow SP installation.

• Comfortable with Maximo and the change management process. Setup maintenance plans. Comfortable migrating data from multiple sources, SSRS reports and SSIS packages. Help business partners create scripts to massage data in their ETL process.

• Provide regular updates on database health to stakeholders. Work with reporting and development teams to tune SQL queries. Manage backup/recovery for SQL Server instances. Performs problem resolution and root cause analysis along with recommending and implementing preventive techniques. Develop in-depth knowledge of business processes facilitated by our software products, Understands principles of database physical and logic design. Monitor the performance of the scheduled jobs and alerts

• Migrate data from different sources including flat files, MS Access, Oracle 11i/ to SQL Server 2012 by using SSIS. Install multiple clients and resolved 32/64 bit driver issues, Microsoft SQL Server 2019, 2016,2014 and 2012 and Windows 2012/2016, 2019.

• Microsoft Analysis Services, Microsoft Reporting Services, Visual Studio Team System and MCDBA

• Work heavily with BBDA (for server builds), Footlight (for monitoring), and Lite Speed (for backup compression).

• Comfortable coding T-SQL.

• Develop in-depth knowledge of our software products. Keep abreast of the changing market for information services and tools. Valkyrie Setups / Configurations / Deployment of EMEA Servers,

• SSRS\SSIS Automations for DR Deployment Scripts / Configurations of Existing SSRS Systems (ENVENTORY) Auto-sys client configurations on SSIS Server pointing to development Auto-Sys Servers

• Work with Windows Operation Team to identify if any spare space available on all of our Rapid DB Development Servers and compile one list of servers.

Bank of America Nov 2013 – Feb 2018

Sr. SQL Server Database Engineer

• Expertise in implementation, administration, troubleshooting and remediation of MS SQL 2014, 2012, 2008 and MS SQL 2005 (SQL Engine, SSRS, SSIS).

• Daily Operational Support Issues / Enhancements / System Stabilizations / Alerts monitoring all Development/UAT & Production Servers (Escalation/Backup Role)

• Development/UAT & Production Servers New Server Builds Supports & Database Certification Status Follow-up and get it operation certified all of our Rapid DB servers (DEV/UAT & PROD Applied patches and service packs to keep the database at current patch level.

• Ongoing database performance tuning and upgrades, including: monitoring and evaluation of all database patches and service packs

• Created Standard Procedures for SQL Server install, upgrade, apply patch and SQL clustering

• Maintain version Patch level on operating system to SQL server 2012,2014,2016

• Developed an in house monitoring system for production environment. To monitor job failures, Audit logins on servers, missing backups of databases, server patch level report etc.,

• Work with engineering teams on logical / physical database design to support new and existing application development. Maintain data models and keep them up to date. Work closely primarily with reporting team to monitor, plan, and implement the synchronization of data across several reporting, development, testing and production environments. Evaluate the merits/ benefits of available system upgrades and enhancements - implement as necessary.

• Develop database specifications, data dictionary, design/coding standards, Run diagnostic tools to identify database performance bottlenecks, and take appropriate corrective actions to improve database performance. Develop tools and reports if necessary.

• Provide regular updates on database health to stakeholders. Work with reporting and development teams to tune SQL queries. Manage backup/recovery for SQL Server instances. Performs problem resolution and root cause analysis along with recommending and implementing preventive techniques. Develop in-depth knowledge of business processes facilitated by our software products.

• Develop in-depth knowledge of our software products. Keep abreast of the changing market for information services and tools. Valkyrie Setups / Configurations / Deployment of EMEA Servers,

• SSRS\SSIS Automations for DR Deployment Scripts / Configurations of Existing SSRS Systems (ENVENTORY) Auto-sys client configurations on SSIS Server pointing to development Auto-Sys Servers

• Work with Windows Operation Team to identify if any spare space available on all of our Rapid DB Development Servers and compile one list of servers

• Implement CIFS Share Backups Routine (Off-site backups) for EMEA/AMRS (once the storage is provisioned) All development servers, Server Build Activities/Server Reconfiguration Activities Backup setup Net backup and Avamar Backup for Production servers

Bank of America Oct 2010 – Aug 2013

Sr. SQL Server Database Engineer

• Expertise in implementation, administration, troubleshooting and remediation of MS SQL 2012, 2008 and MS SQL 2005 (SQL Engine, SSRS, SSIS).

• Implementation - Effectively manage half projects at the same time. These ranged from new implementations to upgrades. Project DBA and cover all issues through BAU. Very comfortable and familiar with BofA Project process. Many of these where none standard and required being a full design partner.

• Administration - Manage several applications as they transitioned to BAU. Several, because of their short life cycle, never left portfolio. Comfortable with Maximo and the change management process. Setup maintenance plans. Comfortable migrating data from multiple sources, SSRS reports and SSIS packages. Help business partners create scripts to massage data in their ETL process.

• High Availability - Implement and support Log Shipping and Mirroring and supported several Disaster Recovery tests.

• Security Remediation: Tightly rolled out security to be consistent with Bank Baselines and application needs

(keeping to the minimum appropriate access required). Expertise in ESM Reports using Discovery tool, which scans the MSSQL Servers/Machines/ Instances as configured, across various domains for various violations. Created views and utilized schemas to restrict access for the security of data in a table. Utilized proxy ID to limit SSIS job vulnerabilities.

• Performance: Optimized database using execution plans and Index tuning.

• Troubleshooting: Effectively use Profiler to find performance issues and deadlocks. Familiar and comfortable with perfmon. Resolve blocking and long running queries through Activity Monitor and Profiler.

• Catch and Report errors using exception handling

• Monitor the performance of the scheduled jobs and alerts

• Migrate data from different sources including flat files, MS Access, Oracle 11i/ to SQL Server 2008 by using SSIS. Install multiple clients and resolved 32/64 bit driver issues.

• Work heavily with BBDA (for server builds), Fog light (for monitoring), and Lite Speed (for backup compression).

• Comfortable coding T-SQL.

Bank of America, Corp. Jul 2009 - Jun 2010

SQL Server DBA/Developer

Bank of America Corporation is a financial services company, with a holding of more than 12% of all U.S. deposits, which is the largest in the United States, by assets and the second largest bank by market capitalization. It has clients in more than 150 countries and maintains relationship with 99 percent of the U.S. Fortune 500 companies and 83 percent of the Fortune Global 500.

• Expertise and Interest include Administration, Security, Troubleshooting and Support mainly on MSSQL Server 2000,2005,2008 and 2008R2 environments.

• Worked as Sr. MSSQL Server DBA to lead the team in audit action plans including security policies & its compliance & remediation.

• Coordinated & assisted the team in compliance & remediation of policies being violated.

• Worked in compliance & audit reporting and its validation.

• Provided support by working with concerned teams for remediation of MSSQL Server database issues, which do not follow the password policies according to the company set regulations.

• Experienced in communicating, coordinating & working with different team DBA Manager's within the Bank of America domain and thereby remediating them according to their priority using T-SQL.

• Prioritized, planned & implemented remediation, according to the weekly server report security alerts provided by the manager.

• Created custom MSSQL Scripts using different join statements to filter data related to the respective servers and DBA's.

• Experience in working with MSSQL Server 2000,2005, 2008 and 2008R2 on 32- and 64-bit environments.

• Involved in Migration of the data to MSSQL Server 2000,2005, 2008 & 2008R2 engines from Microsoft Access using Import & Export Wizards.

• Expertise in ESM Reports using Discovery tool, which scans the MSSQL Servers/Machines/ Instances as configured, across various domains for various violations.

• Worked in the Analyses of ESM Violation Data for creating the Remediation process.

• Worked on Discovery Tool which is the primary tool used in Bank of America for ESM & gathering domain wide information for compliance issues We then use the help of SQL Server, MS Access and ETL for the Remediation of the Compliance issues by coordinating with GIS, Payments/Enterprise/Deposits/Trading/ GWIM / Mortgage/ Ecommerce domain manager's, of a specific application.

• Designed & Implemented Security and auditing procedures of 3,321 MSSQL Server's with a total of 4014 Instances & 36,914 databases.

• Implemented procedures to import data from legacy systems to the current model using MS Access & MSSQL Server Import & Export wizard.

• Managed & worked on reports deployed on MSSQL Reporting Services Report Server.

• Designed and implemented production/development servers as per business / IT needs by setting up, implementing, and maintaining industry & company standards in database management.

• Migrated data from different sources including flat files, MS Access, to MSSQL Server 2005 and vice-versa using ETL.

• Worked with creating procedures for transferring data.

• Designed the Remediation Process Documentation & Servers Details which are supported by Various Domains managers for executive management.

• Coordinated with Technical Development Manager's and their Primary DBA's for implementing procedures to remediate issues that are not in compliance starting from the lower most environment.

• Worked on Blocker PPT Reports and ESM Critical Error Summary and PPT Domain Manager's information.

• Worked on Create Pivot tables and Charts Using the External Data.

• Worked on n Compliance Executive summary reports & Executive summary unchanged reports.

• Worked on Remediation Process Documentation. Servers Details which are supported by Various Domains manager.

• Worked on ESM list of login IDs that have blanks for each production box.

• Worked on Compile list of applications that access production server from ENVentory and AIT.

• Compiled the list of Management Contact, Tech Development Manager, Primary DBA and Secondary DBA for each application.

• For each application and for each environment compiled a list of logins (for both users and processes) that are have blank password.

• Coordinated with Tech Dev Manager and Primary DBA regarding implementing blank password process that is not in compliance, starting from lower environment & Implement process for blank password. Environment: Windows 2000 Advanced Server, Windows 2003 Enterprise Edition, Windows 2008 Enterprise Edition, Windows 2003, Windows 2000, Windows XP, SQL Server 2005, SQL Server 2008, Performance Analysis, Discovery, MS Access 2007, LightSpeed, SQL Server Reporting Services 2005/2008/2008R2 and 2012. Catalent Tech Inc. Jan 2009 - May 2009

SQL Server DBA

• Expertise and Interest include Administration, Database Design, Performance Analysis, and Production.

• Involved in Migration of the Server SQL Server 2000 to 2005 and DTS to SSIS.

• Fixing data issues and writing various SQL scripts and procedures for migration process.

• Worked on High availability environment like clustering, replication, Database Mirroring and log shipping.

• Extensively worked on Snapshot and Transactional Replication.

• Implemented the disaster recovery processes.

• Used DTS jobs for importing data from legacy systems to the current model.

• Worked on DTS, Import and Export utility, BCP Utility and replication tool.

• Responsible for transferring packages using SSIS.

• Created and modified Stored Procedures and Functions to generate reports.

• Monitored and modified Performance using execution plans and Index tuning.

• Rebuilt the indexes at regular intervals for better performance.

• Used log shipping for synchronization of database.

• Day-to-day activities such as backups to the disk and restore the databases and transaction.

• Setup, implemented, and maintained industry standards in database management.

• Monitored SQL server performance using profiler to find performance and deadlocks.

• Developed all the required stored procedures, user defined functions, triggers using T-SQL.

• Good at Data availability solutions like Online Restore, Online index Operation, Database Snapshot, and Fast Recovery.

• Responsible for creating Constraints and Indexes.

• Created views to restrict access for the security of data in a table.

• Caught and Reported errors using exception handling.

• Monitored performance of the scheduled jobs and alerts.

• Performance tuning and testing on stored procedures, indexes, and triggers.

• Generated reports using SSRS.

• Used SSRS to create drill-down and drill-through reports.

• Scheduled jobs and alerts using SQL server agent.

• Migrated data from different sources including flat files, MS Access, Oracle 8i/9i to SQL Server 2005 by using SSIS. Involved in SSIS Package, DTS Import/Export for transferring data. Environment: MS SQL Server 2005, MS SQL Server Reporting Services 2005, SSIS, MS Office, Windows 2003. EDUCATION:

• Post Graduate Diploma in Computer Science

Certifications:

• 70-431 Microsoft SQL Server 2005 - Implementation & Maintenance.

• 70-445 Microsoft SQL Server 2005 - Business Intelligence Implementation & Maintenance.

Contact this candidate