Experience

NRUCFC (National Rural Utilities Cooperative Finance Corporation)

• United States
• Financial Services
• 200 - 300 Employee

• Lead Database Administrator

  • Mar 2019 - Present

   Provide a leadership role in supporting two critical database applications  Manage database security, backups, mirroring, performance tuning, High-Availability, and Disaster-Recovery  Develop enterprise data management warehouse in SQL Server  Utilized built-in and third-party tools for database monitoring, administration, and optimization  Wrote and optimized Stored Procedures, and other T-SQL scripts for day-to-day database activities.  Document all database solutions and related workarounds.  Migrated data from heterogeneous data sources and legacy Access and Excel system to SQL Server databases. Show less



HP Hood LLC

• United States
• Food Production
• 700 & Above Employee

• Sql Server Database Administrator

  • Oct 2018 - Feb 2019

   Install, Manage and regulate SQL server 2005\2008R2\2012\2014 SQL servers.  Implemented one next to the other and in place Migration of MS SQL server 2005/2008R2 to 2012 and connected Patches and Service packs to upgrade distinctive forms of MS SQL server.  Implemented SQL Server 2016 procedure ALWAYS-ON High Availability groups with two secondaries.  Building SQL 2008R2 multi node cluster situations on VMware/Physical situations.  Adding nodes to officially existing clustered servers as a piece of data load\High availability.  Configured Transactional Replication and Log Shipping.  Fix the Cluster and Replication issues on SQL 2005/2008R2/2012/2014/2016 servers with in exceptionally solid SLA's.  Implementation of SQL server logins, Roles and Authentication modes as a piece of security approaches.  Creating and scheduling maintenance plans for updating statistics, checking fragmentation, checking database integrity and backup plans.  Configured Database mail, linked servers, Transparent Data Encryption (TDE) and Auditing.  Performance tuning of databases by windows execution screen and SQL Profiler.  Used Index tuning wizard to update and made the indexes for better performance.  Fine-tuned Stored Procedures utilizing Execution Plan as a part of T-SQL for better execution.  Documenting the standard methods on normal premise.  Used extended occasions/SQL profiler for performance tuning.  Created modified maintenance and observing scripts for Blocking alerts, DBCC checks, Index Reorg/Rebuild, Missing backups and so on.  Ran diagnostics as required keeping in mind the end goal to search for the reason for high CPU use, high I/O and long running queries.  Implemented and kept up a backup and disaster recovery plan.  Analyzed the execution counters, for example, Buffer cache hit ratio, Page life expectancy etc. and agent jobs execution times on production and development servers; altered issues causing slow performance. Show less



Zebra Technologies Inc.

• Lincolnshire, IL.

• SQL Database Administrator

  • Oct 2017 - Sep 2018

   Accountable for monitoring, troubleshooting, and fixing database issues 24x7.  Setup Always-On High availability on 2012 SQL Servers.  Migrating SQL server from 2008R2 to 2012 on standalone and cluster environment.  Tuning the Production server to get the execution change.  Implemented Database Mirroring/Transactional Replication as a piece of high availability and disaster recovery.  Use log shipping for synchronization of database.  Fixed high Memory use issues.  Reorganizing or Rebuilding Indexes considering the Index fragmentation.  Build two-node/Multi-node group on physical/Virtual situations.  Checking Database Health by utilizing DBCC Commands and DMVS.  Added SQL Clustered Node to Existing Cluster for SQL Server 2008R2.  Implementation of SQL Logins, Roles and Authentication Modes as a piece of Security Policies for different classes of users.  Restore Development and Staging databases from production backups according to the necessity.  Creating Backup methodologies and planning them as a piece of database maintenance plans.  To investigate long running slow queries and tune the same to optimize application and system performance.  Managed SQL Server utilizing PowerShell.  Performance Tuning and Establishing incorporated change control.  Documented and Created SLAs (Service Level Agreement) for the server availability in the event of disaster.  Configure Transparent Data Encryption (TDE) on Financial Applications.  Auditing SQL Server logins and access to the databases to identify the active applications/users pointing to the databases.  Researched and implemented SQL 2014 new features such as Delayed durability, Buffer pool extension, Incremental statistics, In-Memory OLTP, Managed lock priority on test boxes.  Involved in point in time recovery.  Created Linked Servers in SQL Server to establish connection to a remote oracle database Show less



Khoj Information Technology, Inc.

• United States
• IT Services and IT Consulting
• 1 - 100 Employee

• Database/Systems Admin

  • Aug 2016 - Sep 2017

   Installed and maintained SQL Server database systems. Monitored success and failure of automated jobs.  Supporting the business 24x7, keeping up 99.999 uptimes, depending upon the application and business SLA necessities.  Experienced with making logical and physical database plan for development ventures.  Experienced with enhancing SQL Server utilizing windows execution screen to enhance the server performance.  Created the reinforcement plan for production, test and development servers.  Worked with developers to do the database schema changes and database restores demands.  Involved in restores operations to refresh the data from production to test servers.  Included in Data Security by keeping up and giving granular authorizations to the clients/login as required, upholding the password strategies and by making proxy accounts.  Implementing Database Mirroring utilizing high safety with automatic failover for Disaster Recovery. Executed New Objects as per the Business necessities. Executed Constraints (Primary Key, Foreign Keys Check and Not Null/Null) and fine tune Indexes on Tables.  Performing fine tuning of Database Application.  Administering the MS SQL Server by making user logins with proper roles, dropping and locking the logins, observing the user accounts, formation of groups, allowing the privilege to user and groups.  Automate and improve every day administrative tasks, including space management, object alteration, backup and recovery and performance monitoring. Show less



Cenvien Technologies - India

• 1 - 100 Employee

• Sql Database Administrator

  • May 2013 - Jul 2015

   Database Performance of Index tuning using Database Engine Tuning Advisor to resolve Performance issues.  Performed security tasks like Grant, Revoke permissions. Implemented security at server, database and object level.  Worked on Data Denormalization using SSIS, analyzing it using SSAS and creating interactive reports using SSRS. Maintained and managed critical Databases.  Implemented High Availability and Disaster Recovery solutions including Database Mirroring, Fail-over Clustering, Log-Shipping and Replication. 24x7 on call support in case of a production environment.  Used Third party tools such as SQL Admin Toolset from Idera (for monitoring and troubleshooting), Litespeed (for backups and restores) and SQL Sentry plan explorer for checking the execution plans to get a clear visibility of trouble spots.  Used SQL Profiler and Performance Monitor for Trend Analysis and Adhoc Monitoring.  Developed database maintenance plan for backup, integrity check and re-index. Performed database recovery operation.  From backup document. Performed point in time recovery utilizing T-log backups.  Setup alert for Memory/CPU use and different Windows services at whatever point down utilizing Solar winds. Show less



Vedam Software Solutions

• Hyderabad Area, India

• MS SQL Server Developer

  • Apr 2011 - Apr 2013

   Monitoring the CPU use, IO Statistics, and CPU time to recognize any OS level Performance executioner.  Wrote and Optimized Stored Procedures, Views, and User-Defined Functions for the application.  Configured Database Mirroring with high performance and high safety (with and without automatic failover) mode.  Troubleshoot for performance related Issues in the servers utilizing DBCC and DMVs.  Monitored disk space issues on the servers. Configured Snapshot, Merge and Transaction replication for high availability.  Implemented log shipping and schedule jobs and alerts utilizing SQL Server agent.  Monitoring and performing daily incremental backups, weekly backups.  With SQL Server, performed backups (Full, Diff, Transaction log) and restores. Moved data to different databases and Created DTS Packages to import data from Excel spreadsheets and Implementing user training and providing technical support.  Involvement in SQL Server investigating rules DNS/Authentication/Data/Common errors Show less