Sonnet Barua

  

Biography:

Work Experience: 5.3 years

Work Experience:

 With over seven years of extensive experience in SQL Server database administration, I am keen to contribute my expertise to your dynamic team. My career is distinguished by
a consistent record of managing and improving complex database systems. My key
accomplishments include: 

· Database Installation and Configuration: Installing and configuring SQL Server database
management systems in line with best practices and organizational needs.
Setting up and managing database servers, including hardware provisioning,
operating system configuration, and database software installation. 

· Database Maintenance and Optimization: Monitoring database performance, including resource utilization, query
execution times, and database throughput. Implementing tuning strategies to
enhance performance, such as index optimization, query optimization, and
database caching. Conducting regular maintenance tasks like backups, restores,
and consistency checks to ensure data integrity and availability. 

· Data Security and Access Control: Establishing security measures to safeguard sensitive data against
unauthorized access, including user authentication, access controls, and
encryption. Defining and enforcing data security policies and procedures,
adhering to industry regulations and organizational standards. Monitoring
database access logs and audit trails to identify and address security
incidents and breaches. 

· Database Design and Schema Management: Working with developers and data architects to create database schemas
that fulfill application requirements and performance objectives. Evaluating
and refining database schema designs for efficiency, scalability, and data
integrity. Managing database objects such as tables, indexes, views, and stored
procedures to ensure consistency and functionality. 

· Backup and Disaster Recovery:
Implementing backup and recovery strategies is crucial to ensure data
availability and continuity in the face of hardware failures, natural
disasters, or other emergencies. Regular testing of backup and recovery
procedures is essential to confirm their effectiveness and to minimize downtime
during a disaster. It is also important to maintain updated disaster recovery
plans and documentation to facilitate response and recovery efforts in crisis
situations. 

· Database Performance Optimization: Implementing performance-tuning strategies that significantly improved
query execution times and overall system efficiency, resulting in enhanced user
experiences and cost savings. 

  

Additionally,
my expertise includes the following areas: 

Ø SQL server High availability (Log shipping, Mirroring, Replication, Failover
Clustering, Always ON) 

Ø SQL server Performance tuning 

Ø SQL server troubleshooting 

Ø SharePoint 

Ø PowerShell 

Ø SQL Server Integration Services (SSIS) 

Ø SQL server Reporting services (SSRS) 

Also I possess strong problem-solving skills, outstanding communication abilities, and a
collaborative spirit. I excel in working within cross-functional teams and
partnering with developers, system administrators, and various stakeholders to
meet shared goals. 

   

Work history:

  • Job Title: Database Engineer

    Company: Navy Federal Credit Union

    Period: June 2024 - present

    Role Description:
    • Responsibilities:
    • Successfully installed, configured, and maintained SQL Server versions 2019, 2017 and
      2016 in development, testing, and production environments.
    • Implement and maintain Always On Availability Groups.
    • Experience in maintenance planning, scheduling SQL Agent Jobs, and troubleshooting.
    • Monitor and troubleshoot issues in SQL databases and address and resolve space-related
      concerns.
    • Managed permissions through AD Groups, AD Users, SQL Users, SQL Logins, Roles,
      and Schemas.
    • Binding SSL certificates on the SSRS server.
    • Create databases, logins, roles, and grant appropriate permissions.
    • Monitor performance to optimize database operations concerning memory, CPU usage,
      blocks, fragmentation, and long-running queries.
    • Perform database maintenance tasks such as rebuilding/reorganizing indexes and
      updating statistics.
    • Shrink database files as needed to enhance performance.
    • Set standards and timetables for database backups and restorations to meet business
      requirements.
    • Document the company's database environment thoroughly.
    • Keep Updated database server repository.
    • Helping Apps team to rotation/ Update their service account password.
    • Performing Change task, release task, and catalog task
    • Proactively monitored, determined and solved issues at SQL/database/server levels.
    • Provide 24x7 operation supports on all the Production, Test and Development databases.

  • Job Title: SQL DBA/ Database Administrator

    Company: U.S. Department of Labor

    Period: August 2023 - May 2024

    Role Description:
    • Responsibilities: 
    • Installed, configured, and maintained SQL Server versions 2019, 2017, 2016 and 2014
      across development, testing, and production environments. 
    •  Managed over 100 MS SQL Server instances in a production setting. 
    •  Gained experience in AlwaysOn configurations. 
    •  Handled permissions using AD Groups, AD Users, SQL Users, SQL Logins, Roles, and
      Schemas. 
    •  Renew, New and Decom the TLS Cert to the Server. 
    •  Participating Change Management Meeting. 
    •  Documents keep updated in SharePoint. 
    •  Conducted upgrades/migrations of SQL Server Instances/Databases from older versions
      to newer ones, such as from 2012 to 2017. 
    •  Applied Service Packs (SP) and Hot Fixes to SQL Server Instances to address security
      issues and perform upgrades. 
    •  Executed database and SQL/T-SQL performance tuning. 
    •  Automated various database-related tasks such as backups, monitoring database health,
      disk space, and backup verification through scheduled jobs. 
    •  Established Jobs for backups, index rebuilding, server health checks, alerts, and
      notifications. 
    • Employed the Import/Export Tool for data transfer from various sources including SQL
      Server Databases, flat files, CSVs, Excel sheets, and other data sources compatible with
      ODBC and OLE DB. 
    • Performed manual and on-demand database backups, designed backup strategies, and set
      up related jobs. 
    •  Deployed and restored databases including Point in Time Recovery. 
    • Monitored server activity, error logs, space usage proactively to identify and resolve
      issues as needed. 
    • Attended an ATO meeting focused on minimizing and managing risk responsibilities. 
    • Taken action based on automation disk report on that. 

  • Job Title: Database Analyst

    Company: Infosys (Pfizer Project)

    Period: August 2020 - July 2023

    Role Description:
    • Responsibilities: 
    • Install and administer SQL Server versions 2008, 2012, 2014, 2016, 2017, and 2019. 
    • Migrate databases from SQL Server versions 2008, 2012, 2014, 2016, and 2017 to the
      AWS environment as part of the execution team. 
    •  Create logins/users and assign appropriate permissions upon request. 
    •  Implement mirroring as a high-availability option. 
    •  Provide round-the-clock production support to over 7500 databases across various
      environments such as Production, Stage, Development, etc. 
    •  Support SQL Database versions ranging from 2008 to 2019. 
    •  Perform database maintenance tasks such as rebuilding/reorganizing indexes and
      updating statistics. 
    •  Check database integrity and regularly clean up history. 
    •  Monitor and troubleshoot SQL Database issues. 
    •  Troubleshoot space-related issues. 
    •  Bind SSL certificates on the SSRS server. 
    •  Implement and maintain AlwaysOn Availability Groups. 
    •  Monitor performance to optimize database operations concerning memory, CPU usage,
      blocks, fragmentation, and long-running queries. 
    •  Monitor user accounts, create groups, and grant database and application roles to users
      and groups. 
    •  Optimize database performance using DMV, Activity Monitor, and Extended Event Error
      Log. 
    •  Shrink database files as needed to enhance performance.
    • Coordinate effectively with client stakeholders and offshore teams regarding work
      assigned for each iteration.  

  • Job Title: SQL Server DBA

    Company: Infosys (Microsoft Project)

    Period: March 2020 - July 2020

    Role Description:
    • Responsibilities:   
    •  Conduct backups, restorations, configurations, and installations for Microsoft SQL
      Server versions 2008r2, 2012, 2014, and 2016. 
    •  Execute database migrations from SQL Server 2008 to 2012 in both test and production
      environments. 
    •  Oversee the deployment and upgrade processes for application-related databases,
      providing support and maintenance for existing systems. 
    •  Apply Service Packs (SP) and patches to SQL Server to enhance performance, alongside
      developing and maintaining MS SQL server databases. 
    •  Establish and administer SQL Server security policies and transparent data
      encryption(TDE). 
    •  Set standards and timetables for database backups and restorations to meet business
      requirements. 
    •  Guarantee that all database servers are backed up in a manner that aligns with the
      business's Recovery Point Objectives (RPO). 
    •  Verify backups through testing to confirm the business's Recovery Time Objectives
      (RTO) can be met. 
    •  Aid in the design, implementation, and maintenance of databases. 
    •  Ensure the inclusion and ongoing update of all database system-related data and
      documentation on SharePoint. 
    •  Configure and sustain Log Shipping, Mirroring, and Always ON setups. 
    •  Monitor and diagnose issues with High Availability and disaster recovery strategies,
      including Log Shipping, Mirroring, and Always on Availability Groups. 
    •  Address and resolve problems related to database availability, connectivity,
      performance, and security. 
    •  Configure and maintain Database mirroring with the high safety automatic fail-over
      option. 
    •  Implement SQL Server 2012 ALWAYS-ON High Availability groups with two
      secondary nodes. 
    •  Identify and rectify issues when the WSFC cluster service or an Availability group is
      offline. 
    •  Apply patches and hotfixes on Always-On Failover Cluster Instances (FCI) in both
      production and non-production environments. 
    •  Ascertain the most effective methods to enhance performance as issues emerge. 
    •  Document the organization's database environment thoroughly. 
    •  Participate in code reviews to ensure quality control. 
    • Engage in continuous performance monitoring to prevent issues from arising. 

  • Job Title: SQL Server DBA

    Company: Infosys (Verizon Project)

    Period: December 2018 - February 2020

    Role Description:
    • Responsibilities: 
    • Establish standards and schedules for database backups and restorations. 
    •  Ensure that all database system-related data and documentation are added to and
      maintained within SharePoint. 
    •  Configure and maintain Log Shipping and Mirroring. 
    •  Document the company's database environment thoroughly. 
    •  Monitor performance to identify methods for optimizing database performance, including
      memory, CPU, disk utilization, I/O, blocks, deadlocks, fragmentation, and long-running
      queries. 
    •  Optimize teamwork processes and practices by actively participating in the agile process. 
    •  Experience migrating SQL Server databases to the OCI environment (Oracle Cloud
      Infrastructure). 
    •  Identify and resolve database performance and capacity issues. 
    •  Create databases, logins, roles, and grant appropriate permissions. 
    •  Experience in automating jobs for various database-related activities, including backup,
      monitoring database health, disk space, and backup verification. 
    •  Experience in maintenance planning, scheduling SQL Agent Jobs, and troubleshooting. 
    •  Monitor databases for optimal performance using SQL Profiler, DMVs, Activity
      Monitor, Extended Events, Error Log, and Windows Performance Monitor. 
    • Shrink databases as necessary to enhance performance. 
    •  Use DBCC to check the physical and logical consistency of databases. 
    •  Maintain and document shell scripts and batch processes. 
    • Provide round-the-clock support for all Production, Test, and Development databases. 

Education:

  • Premier University

    Bachelor's Degree – Bachelor’s Degree in Science

    Period: January 2007 - July 2011

Connect
if you are a job seeker click here