K Sindhu
Senior Sql Database Administrator @Moody's Corporation
Signup · Get unlimited contacts
WORK HISTORY
Senior Sql Database Administrator @Moody's Corporation
Charlotte, NC, US
Designed and Developed Database Objects like Tables, Stored Procedures, Triggers,Rules, Defaults, user defined data types and functions for this project. Developed, tested and implemented Referential Integrity rules and regulationsthrough constraints, triggers and views, partitioned views. Created Views for specific columns on a table to maintain privacy of a customer data. Created Indexes to get the high level performance. Performing the ETL operations to support the incremental, historical data loads andtransformations using SSIS. Designed SSIS packages for synchronizing the data between two different servers. Maintained databases, performed software installations and upgrades, monitoredDatabase Performance. Responsible for gathering Business Requirements and System Specification fromusers. Designed numerous ad-hoc and custom reports using SQL Reporting Services. Created various Tabular and Matrix Reports using SSRS. Involved in designing the reports in ProClarity. Database administration of Sql server and Oracle databases Installation and promotion of latest versions of sql server 2012 with advancedfeatures of always on Configuring and setup of analysis services integrated with shareporint and Created and scheduled jobs for various tasks and also was responsible for maintainingjobs through AutoSys.
EDUCATION
Kent State University
Master's degree, Computer Science
ABOUT K SINDHU
Over Ten years of experience in Administration, Developing, Implementation and Support of MSSQL Server 2017 & 2019 versions and Azure, AWS in Development, Test,UAT and Production EnvironmentsInstallation and configuration of SQL servers with Health Care & financial applications, Manufacturing and IT sectorsSpecific hands-on experience includes administering large and complex Databases, Database DesignEntity relationship diagram (ERD) development normalization and physical database schema designPerformed Log Shipping and implemented Transactional and Snapshot Replication as high availability techniquesExtensive involvement in complete Software Development Life Cycle (SDLC) including System Requirements Collection,Architecture,Design,Coding,Development,Testing.Support and Enhancement of an assortment of technological stages.Experienced with Change Data Capture (CDC) for insert, update and delete in SQL tablesCreated custom-tailored database backup/restore scripts for Full, Differential and Transactional backups and scheduled jobs for DBA automation task. Upgraded/migrated databases from lower version of database to higher versionExperienced in Migrating data between servers(Oracle, MYSQL, Staging, Data warehouse),Database of OLAP/OLTP and Mirroring as disaster recovery solution & Encryption of Databases on Master DB level,Table level and column level using self-signed certificates and TDE keys for securing the top priority dataImplemented Always on Availability Group on Multiple instances on SQLServer 2017 and 2019Experience in supporting Very Large databases (4TBto12TB) and troubleshooting the problems & with 2012/2014/2016/2017/2019 concepts like data partitioning, indexing, DDLtriggers,DMVT-SQL in writing triggers, tables, user defined functions, views, indexes, and relational database models and data integrity, and experience in migrating to SQLServer2017/2019Extensively used tools like SQL Profiler, Index Tuning Wizard,and Windows Performance Monitor for tuning and monitoring SQL Server performance,Proficiency in Performance Tuning, Query Optimization Client/Server connectivity, and Database Consistency Checks using DBCC Utilities, DMVs and DMFsPerformance Tuning, Query Optimization, Client/Server Connectivity,Database consistency checks using DBCC utilities and Index Tuning WizardIntensive experience in monitoring database performance using SQLProfiler, and the DB’s percent log space for all database servers using SCOM and Windows Performance counters
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.