SUDHAKAR KANTAMNENI

Jupiter, FL *****

Cell : 917-***-****

Objective

Seeking a challenging position in the IT department as a SQL Production DBA / SQL Developer DBA / SQL Developer

Experience Summary

26 years of professional experience(US) in a wide range of Database Development, Data Management, Application development and Server / System maintenance environment, setting up Windows Failover clusters etc.

More than 8 years of SQL Developer work, coding of Procedures, Functions and Triggers using T-SQL.

More than 18 years of Production DBA experience in SQL Server 2022/2019/2017/2016/2012/2008 from 7.0/6.x, including Database Development, Administration and Server Level programming.

Microsoft Certified in SQL Server 6.5 administration and Windows NT Server.(April 1997).

4 years experience in building data warehouses, for Reporting and Analysis purposes.

4 years of experience as the Systems Administrator of a Windows 2000/NT Network.

Have excellent written and verbal skills, Able to Organize and Plan work independently, Share on-call rotation.

Computer Skills

Database Systems: SQL Server 2022/2019/2017/2016/2014/2012/2008(From SQL 7.0 6.x),

Sybase System 12.5, Oracle 9i, 10g

Data Modeling Tools: Erwin 3.5.2 and 4.1,Data Modeler r7, Visio 2000, Sourcesafe, PowerDesigner

Performance Monitoring Tools: Profiler, Perfmon, Indepth 1.5 from Precise / Veritas, SolarWinds, LiteSpeed

Data Management Tools: Power BI, Informatica PowerMart 4.6.1, Analysis Services, SSIS/DTS

Documentation Tools: Office 365, Office 10(MS Word, Excel), PowerPoint

Operating Systems/ Languages: T-SQL, SQL, Windows 2016/2012/2008/2003/2000/NT 4.0 Server

Professional Qualifications

Attended Microsoft courses on Performance Tuning, Windows Administration, Sharepoint Management

Attended a 2-day training session on BI for SQL Server 2008 conducted at Microsoft, by Brian Knight.

Attended a 2-day training session for SQL Server 2005 Upgrade conducted by Microsoft.

Certification April 97 from Microsoft in SQL Server 6.5 administration, Windows NT 3.51 (server and workstation).

Certified as an MCPS (Microsoft Certified Product Specialist.)

Certified NetWare Engineer CNE 4.1, certification from Novell Inc.

Bachelor's in Engineering in 1990, from Osmania University, India.

PROFESSIONAL EXPERIENCE:

DSS Inc, Juno Beach, FL Aug. ’23 – Oct. ‘23

Role : SQL Server Developer DBA

Environment: SQL Server 2019 on AWS and Azure, Windows 2022 / 2019

SQL Server Developer and Performance DBA

Installed SQL Server 2019 on two AWS cloud servers and combined them as a Windows Failover Cluster and configured the SQL High Availability Always On availability groups – added databases to replicas.

Monitoring for DB maintenance job runs, by logging onto Jumpbox and monitoring 3 node Demo cluster environment.

TBC Corporation, West Palm Beach, FL Apr. ’15 – May ‘23

Role : SQL Server DBA, SQL Developer, Systems Administrator III

Environment: SQL Server 2022/2019/2017/2016/2014/2012/2008R2/2005, Windows 2016/2012/2008/2003/2000

SQL Server Production DBA performing SQL Installation, Always On High Availability setup, Replication setup and management, Security Management, Database Migration, SQL Job monitoring, Database Maintenance Plans, Production Troubleshooting for Performance, Migrating SSIS Projects, Reports from QA to PROD following change management process.

Responsibilities

Develop, Deploy, Optimize, Maintain SQL Servers -versions 2022/2019/2017/2016/2014/2012/2008R2

Administration, Permissions Management, Optimization of SSRS Reports, SSIS packages to support business needs

Design tables, develop stored procedures, functions, optimize SQL code using execution plans, hints, indexes

Business requirements gathering, analysis, SSIS projects / packages, debugging issues in complex SQL queries

BIDS used to develop SSIS packages, Management studio for replication, Job scheduling, Job failure alerts

Space Management, attending to DB issues of third party software SolarWinds, ServiceDesk, OpenText etc.

Troubleshooting Performance issues – using native monitoring and performance tools – Profiler, Perfmon

Setup Failover Cluster Instances, Configure Always on High Availability SQL server replicas for grouping databases

Replication setup(USA and Mexico), monitoring, Server Upgrades, Database Migration, Restores to QA/DEV

Setup Database backups, Log Backups to mitigate data loss as part of DR planning based on recovery models

24x7 support on a rotation basis as part of 8-member Systems Administration team – Primary for all SQL issues for P1, P2, P3 tickets helpdesk tickets.

Palm Beach County School District, West Palm Beach, FL Mar. ’07 – Apr. ‘15

Role : SQL Server DBA – Development and Production

Environment: SQL Server 2012/2008R2/2005, Erwin Data Modeler r7, Windows 2012/2008/2003/2000

SQL Server DBA performing SQL Installation, Database Migration, Creating SSIS packages for daily data loads and automating the same. Design and build the table structures for different databases that were earlier created in MS Access.

Responsibilities :

SQL Server 2012/2008R2 Installation, Administration, Configuration, and Maintenance of SQL Servers in different environments for Development, QA and Production.

Windows Server support including Clustered Server installation, adding Roles/Features, user group management on SQL Server, reviewing Event Logs, troubleshooting SQL issues, Perfmon etc

Consolidating databases onto multiple SQL Server Instances in the Production cluster environment.

Involved in Security Management, Permissions, Backup planning, DR strategy planning etc.

Designing database objects, Index Planning, writing Stored procedures to be called by Application by translating Business requirements and Logic as presented by Business users.

Designing Maintenance plans, SQL Jobs and Reviewing DTS/SSIS packages for automating different tasks and promoting the DTS packages to various environments.

Troubleshooting performance-related problems on SQL Server 2008 and using SQL profiler to monitor activity, when application slowdown is reported.

Created scripts for database creation, table creation, Index creation, pre-populated data and stored procedure creation for releasing to SQL Server instances.

Copying databases from Production to Development, promoting Table and Stored procedure changes as necessary.

Sovereign Bank, Dorchester, MA Jun. ’06 to Dec. ‘06

Role : SQL Server Developer DBA

Environment: SQL Server 2000, Erwin 4.1, Windows 2k/2003

Member of the Automation and Integration Group involved in the Onsite Banking Project, which is an effort to facilitate New account openings via Bank representatives(with Laptop machine) visiting a Business organization location. Primary role is to design and build the table structures for different databases that would host data on standalone laptops and then synchronize with a central project database and onward loads to the Mainframe system.

Responsibilities :

Gathering data elements and designing Table structures.

Designing database objects, Index Planning, writing Stored procedures to be called by Application by translating Business requirements and Logic as presented by Business users.

Planning for Scalability, High Availability and DR in the near future.

Citizens Financial Group, Providence, RI Mar. ‘05 to Jun. ‘06

Role : SQL Server DBA

Environment: SQL Server 2000 / SQL 7, Erwin 4.1, Citrix, Legato Networker, Windows 2k/2003

Member of the Production DBA team supporting 150 plus production SQL Servers, The DBA team supports development for internal customers and reviews/approves vendor developed applications. Creating entities, Identifying Relationships, Translating user requirements into design specifications, Table design, T-SQL code to meet company standards and performance requirements, participating in review meetings etc are all part of my responsibilities.

Responsibilities :

Administration, Configuration, Server Hardening and Maintenance of SQL Servers in different environments for Development, Integration and User Acceptance Testing.

24x7 support on a rotation basis as part of a 3-member team handling 150 plus production servers.

Consolidating databases onto multiple SQL Server Instances in the Production cluster environment

Running SQL Server Hardening scripts and Service Packs on newly installed SQL Servers to maintain uniform standards and Security across all servers managed by the DBA team.

Troubleshooting performance-related problems on SQL Server 2000 and using SQL profiler to monitor activity, when server slowdown is reported.

Involved in Security Management,, Legato Backup(Network) monitoring and DR strategy planning etc.

Participated in Change Management meetings to support changes being promoted to production and implemented approved changes to production.

Created scripts for database creation, table creation, Index creation, pre-populated data and stored procedure creation for releasing to SQL Server instances.

Citrix administration – to monitor tickets dispatched to the data management team, and take appropriate actions.

Designing SQL Jobs and Reviewing DTS packages for automating different tasks and promoting the DTS packages to various environments.

Copying databases from Production to Development, or promoting Table and Stored procedure changes as the need may be.

Used ERWIN 4.1 for Logical / Physical modeling of Database objects enforcing Referential Integrity, after identifying business requirements.

Publishing the Entity Relationship diagram for developers to code against, and Review / Promote stored procedures presented by developers to dbo – to be used by applications, and granting appropriate permissions.

Participated in Design review meetings with Business departments to suggest changes to various ideas, to meet company standards.

Reuters, Times Square, New York Jul. ‘04 to Dec. ‘04

Role : SQL Server Developer DBA

Environment: SQL Server 2000, Windows 2003, Erwin 4.1, Visio 2003, .NET

The company plays a major role in developing products for Equities transactions, marketed to financial companies. Primarily responsible for designing clustering and replication, for high availability and business continuity respectively for the T+ project. Infrastructure planning, database grouping and co-ordination with Production DBAs to maintain company standards from design stage. Also responsible for providing query performance tuning, trouble-shooting support for the SQL servers.

Responsibilities :

Logical and Physical modeling of tables, using Erwin 4.1 and implemented constraints to check business rules and data integrity.

Worked with Application developers and coded SQL Server procedures, Triggers and User Defined Functions.

Created scripts for database creation, table creation, pre-populated data and stored procedure creation for releasing to SQL Server instances.

Actively involved in Designing databases, Space Estimation, and breaking up of large tables for easier management.

Co-ordinate with company SQL Server Operations team so that design meets standards in place.

Created SQL Server job that can be called on adhoc basis for releasing code changes across all development environments.

Troubleshooting performance-related problems on SQL Server 2000 using SQL profiler.

Creation of Maintenance plans for Database/Log backups, Rebuilding indexes and Integrity Checks, application of service packs etc for non-production boxes.

Designed and tested SQL Server replication from the transaction databases to reporting databases and also from primary data center to disaster recovery location.

Design of Cluster Services on Windows 2003 server for High Availability.

Satori Group, Conshohocken, PA Feb. ‘04 to Apr. ‘04

Role : SQL Server Developer

Environment : SQL Server 2000, Windows 2000, Erwin

Worked as a SQL Server developer developing stored procedures that would create procedures dynamically, based on the dimensionality of the client’s warehouse environment. A tool called ProCUBE, has been developed by Satori Group that uses the Warehouse database to provide standard reporting, similar to analysis Services. The idea was that creating procedures dynamically would reduce the cost and time needed for implementation at a client-site.

IMS Health, Pennsylvania Apr. ‘03 to Dec. ‘03

Role : SQL Server DBA – Production Support

Environment : SQL Server 2000, Windows 2000/2003, Erwin, Microstrategy 7.2, Precise

IMS is a major source for pharmaceutical market intelligence, providing prescriber information, analysis and services that drive marketing decisions in pharmaceutical companies. Worked as a Production DBA, providing 24/7 support, query performance tuning, trouble-shooting support for the SQL servers.

Responsibilities :

Administration, Installation(Upgrade 7/6.5 to 2000 and Service Packs), Configuration and Maintenance of SQL Servers.

Coded SQL Server procedures and designed DTS packages for Transforming data from the staging tables to Warehouse tables and also to check business rules and data integrity.

Logical and Physical modeling, using Erwin 3.5.2 and storing database models in ModelMart.

24x7 support on a rotation basis as part of a 4-member team handling 30 plus production servers including UK, Germany and Australia environments.

Installed Cluster Services on Windows 2000 server, and installed SQL Server 2000, for High Availability. Installed and maintained an Active/Active cluster.

Creation of Maintenance plans for Database/Log backups, Rebuilding indexes and Integrity Checks, application of service packs etc.

Supported 85-90 servers in different environments for Development, Integration, User Acceptance Testing and Production including code-release.

Space Management, Creation of databases, Moving databases by attaching physical files copied from another server or by Restoring from Backup dumps.

Planning for Server consolidation and grouping of databases.

Troubleshooting performance-related problems on SQL Server 2000 and 7 using SQL profiler.

Used Analysis Services Manager to Design and build the cubes to present Region, District and Territory information of Prescriber data.

Analyzed the requirement, designed the Data Warehouse using Star-Schema methodology and converted data from various sources to SQL Server tables.

Log Shipping from Production to UACC, for maintaining latest data from Production Environment and Replication to Oracle Test environment..

Indepth from Veritas for SQL Server Performance monitoring, for the Warehouse Load Server.

Implemented one-way replication from Oracle to SQL Server.

Metlife, New Jersey Apr. ‘02 to Dec. ‘02

Role : SQL Server DBA / Warehouse Developer

Environment: SQL Server 7/2000, Windows 2000, Erwin 3.5.2, Microstrategy 7.1

Worked as a senior SQL Server DBA primarily developing procedures to load the Data Warehouse on a nightly basis. COMS project(Complaints Online Management System) is a major effort on the part of Metlife to meet with Compliance. Table design, Table creation, procedure coding and tuning for the Data warehouse to meet all the user requirements for reporting on data.

Responsibilities:

Developing and Performance Tuning of SQL procedures for nightly loading of the Data Warehouse, to be used by Microstrategy.

Documentation of code developed, Specifications designed based on user interaction.

Index planning for better performance of Data retrieval procedures.

Study Logical and Physical design of tables using Erwin 3.5.2

Database maintenance planning, Database consistency checking(DBCC) and rebuilding indexes.

SQL Server Database design, development, User privileges planning, Security etc.

Sankyo Pharma, Parsippany, NJ Oct. ‘01 to Apr. ‘02

Role : SQL Server Developer / Project Management System

Environment: SQL Server 2000, Windows 2000, Erwin 3.5.2, Project 2000, Project Central, Coldfusion 5.0

Worked as a senior SQL Server 2000 DBA/Data Modeler in the production environment and development of new projects. Identified and Designed data elements for the Project Management System created to track a project from customer submission to approvals, to implementation and customer sign off. Established table relationships and created procedures to be called by the Coldfusion application for data retrieval and presentation.

Responsibilities:

Logical and Physical modeling of tables using Erwin 3.5.2

Creation, Release management of SQL procedures and supporting files.

Designed Staging Environment to have previous 2 versions of databases.

Performance Tuning of SQL procedures developed for the Coldfusion application.

Project 2000 was used to create, test and publish projects to Project Central.

Project Central administration to enable web-based access to customers to allocated project tasks.

Space creation and management for Databases on different servers.

Developed database maintenance plans for backups, integrity checking and rebuilding indexes.

SQL Server Administration, Production support, Security etc.

Installation of Windows 2000 and SQL Server 2000 software on Production, development and staging servers.

S.G. Cowen, New York, NY Jul. ‘00 –Aug. ‘01

Role : Sr. SQL Server DBA

Environment : SQL Server 2000/7.0, Windows NT 4/2000, MS Project, Erwin, Visio 2000, SourceSafe.

S.G. Cowen is the US affiliate of Paris-based investment bank Society Generale. Developed and implemented upgrade to SQL Server 2000/7. Designed/Planned a star schema for a Data-Mart of Research coverage subscribers.

In addition to DBA responsibilities, Designed and developed IGMS(Invoice Generation and Management System) application for the IB support / Capital Markets Technology group. Setup of Database and space management plans for IGMS application. Identified data elements, logical and physical design of tables, established relationships and created procedures for SQL transactions of IGMS, to be used by the front-end VB application.

Responsibilities

Design and planning of databases, space management etc.

Logical and Physical modeling of tables using Visio 2000 and Erwin 3.5.2

Developed enhancements and tuned SQL procedures of various applications supported by the Capital Markets Technology group.

Visual Sourcesafe used for version control of code moved to production.

Backup and Recovery strategy to avoid single point-of-failure.

Security management, performance and tuning to overcome hardware and software bottlenecks.

Developed, tested and implemented one-way replication between SQL 7 servers.

Developed database maintenance plans for checking and rebuilding indexes.

Used MS Project to track deadlines and progress of allocated work.

Designed Staging Environment to have previous 2 versions of databases.

Wrenchead Inc., White Plains, NY Apr. ‘00 – Jul. ‘00

Role : Sr. SQL DBA

Environment : SQL Server 7.0, Windows NT 4.0, SQL Probe, PowerDesigner, Visual Basic 6.0

Wrenchead is in the business of cataloging auto parts manufactured by various vendors. Data management and creation of DTS packages to create the master catalog by transforming the catalogues of the affiliated vendors. OLAP package designed for studying coverage of parts sold in newer versions of the catalogue.

Responsibilities

Responsible for the B2B production server including server installation, troubleshooting, backups, SQL server availability and maintenance task planning and scheduling.

SQLProbe and Perfmon used to monitor SQL Server and Windows NT servers.

Moving catalog tables, transferring objects, planning for backup of databases, controlling user access.

Creation of DTS package to run a match of the vendor’s parts data against the standard catalog, and capturing non-match parts for research.

Tuning procedures used by the front-end ASP/VB application against very large tables, for excellent response time.

Used OLAP services to identify part coverage based on inventory details provided by different part vendors.

Indexing tables, after studying the procedures, and considering the space requirements.

Prudential Insurance, Livingston, NJ Aug. ‘99 - Mar. ‘00

Role : SQL DBA / Production DBA

Environment : SQL Server 6.5, DB2, Erwin 3.5.2

Worked as a Production DBA in the SQL Server Support group. Actively supported the ADRDM data conversion group / process for feeding the data to a mainframe DB2 system. A cut of the production database is restored on the SQL server and procedures are called for data summarization, data massaging and feeding the same to the mainframe DB2 system as flat files.

Responsibilities

Developed procedures for creating and loading summarized data tables, creating views, bulk-copying to flat files, and transferring the same to the mainframe using FTP utility.

Automation of deletion of users/groups from restored databases, and adding users/groups valid for the current server, and granting permissions.

Involved in writing, testing and tuning of stored procedures to run against huge tables.

SQL Server administration, Backups and restore, Index management, running database consistency checks, User & security management etc.

Building Windows NT servers, application of service packs, SQL Server installation and version upgrade.

Evaluating Hardware and space requirements, planning for database growth.

Burnham Corporation, Atlanta, GA Feb ‘99 to Jun. ‘99

Role : Production DBA

Environment : SQL Server 6.5, Datamirror 4.1, AS400, Oracle 7.3, Brio Query Designer 5.5

Burnham corporation is a warehouse management company, to companies like IBM, SUN, DELL and provides a 'Parts-On-Time' service in a tie-up with Airborne Express, and ships parts to the customer. SQL Server acts as the Data Warehouse and is populated by replicating order related data from AS400 and Oracle databases. A second SQL Server stores data and accepts orders from a web-based application server. DataMirror, a third party software is used for Replication.

Responsibilities:

SQL Server Installation, Configuration and Performance tuning.

Design and Implementation of Backup/Restore procedures.

Replication was setup using DataMirror 4.1 between SQL Servers, and between SQL server and AS400 & Oracle.

Creation of Databases, Tables, Indexes and Views.

Creation of logins, user/group accounts, resolving ODBC connectivity issues.

Scheduling events to run daily, weekly and monthly procedures for database maintenance.

Used PowerDesigner to reverse engineer the database for documentation purposes.

Developed triggers and stored procedures to support end-user requirement.

Design of BRIO datamodels for users to generate reports.

MCI Inc., Cedar Rapids, Iowa. Oct. ‘97 - Jan. ‘99

Role : Developer / Database Administrator

Environment : SQL Server 6.5, Data Warehousing, Sybase 11, MS Access 2.0, Visual Basic 5.0

MCI Inc. sells various telecommunication services. CSSRD group develops data summarization processes to load the repository(Data Warehouse) from 12 identical remote servers across the USA. CSSRD also develops reports for the upper management to track performance of different telemarketing centers & various products.

Responsibilities:

Installation of Windows NT 4.0 and SQL Server 6.5.

Creation of Devices, Databases, Tables, Views, Rules and procedures for SQL Server 6.5.

Management of Logins, Tables, Indexes, Databases & Devices.

Documentation of the existing system & modifications undertaken.

Developed Procedures, Triggers and Data Extracts for automation of data collection.

Loading data into Temporary tables, massaging and loading data into permanent tables.

Performance tuning of procedures for faster data retrieval.

Co-ordination with front-end programmers, for Optimization of the system.

Automation of the procedure for Database Backups.

SpecTran Corporation, Sturbridge, MA Aug. '97 - Oct.'97

Role : Production DBA

Environment : SQL Server 6.5, Windows NT 4.0, Datamirror400, AS400

SpecTran Corporation develops, manufactures and markets glass optical fiber & value added fiber optic products. Software from DataMirror Corporation is used to replicate data from the AS400 machine to the SQL Server, which is accessed by users to generate various reports.

SQL Server runs on a HP NetServer P5/166 LS configured for RAID with 6 disks of 4GB, running Windows NT 4.0. Main responsibilities were,, & software were loaded to enable backup and replication respectively.

Responsibilities:

Installation and Administration of Windows NT 4.0 and SQL Server 6.5.

Rebuilt the Windows NT server after the hardware upgrade by reinstalling all software, SQL Server and restoring databases.

Creation of Devices, Databases, Tables and Procedures.

Performance tuning by configuring the server parameters, adding Indexes and Query-tuning.

Login and User management to enforce security. User/Permission cleanup in restored databases.

Installing SQL Server Client Utilities on the client machines and resolving connectivity issues.

Cheyenne's ArcServe 6.0 used for Backup Management - Scheduling & Testing of backups.

DataMirror400 used for replication of Data from AS400 to SQL Server.

Other

Excellent communication skills.

References will be furnished upon request.

Aug 1997 to Dec 2004 – Employed by Sigma Systems, Savant Inc and Compu-Info, working at client sites mentioned.

Contact this candidate