Pinnel Boyal

• Designed scalable, secure, reliable, and high-performing databases based on industry best practices.
• Provided technical support for database system applications, troubleshooting errors, and advising on query optimization.
• Executed daily maintenance duties, including backups, restores, and log shipping operations.
• Conducted root cause analysis to resolve database system issues.
• Participated in project teams to develop solutions that seamlessly incorporated SQL Server databases into larger system architectures.
• Implemented replication between servers to ensure system availability.
• Maintained disaster recovery plans, ensuring backup schedules and testing procedures were in place to recover from unforeseen events.
• Developed and implemented data strategies for enhanced integrity, reliability, and availability.
• Analyzed current databases to identify areas for enhanced efficiency through restructuring or re-indexing techniques and developed scripts to automate routine administrative tasks.
• Contributed to the implementation of robust database systems through the creation and maintenance of tables, views, functions, and stored procedures.
• Deployed patches and upgrades in accordance with change management policies.
• Collaborated with the IT team on database integration with other applications.
• Optimized database systems through performance tuning for enhanced efficiency. Resolved complex issues related to software tools, applications, and databases for users.
• Provided scalable solutions by aligning systems with business needs and making recommendations for improvement in database structures.
• Participated in disaster recovery planning and testing to minimize data loss.
• Managed user access and privileges to secure sensitive data effectively.
• Coordinated with development teams to optimize database queries and indexes.
• Prepared and maintained detailed documentation for database architectures and procedures.
• Monitored database performance and implemented changes to improve response times.
• Oversaw the installation and maintenance of database software and updates.
• Developed and enforced database administration policies and procedures.
• Managed and facilitated successful database migration and upgrade projects for seamless transitions.
• Managed database security, implemented backup and recovery procedures to safeguard information. Provided support in disaster recovery planning through the testing of different backup strategies and scenarios.
• Implemented automated routines for database tasks, enhancing system reliability and decreasing manual errors.
• Migrated existing databases from one platform to another with minimal downtime.
• Provided technical support for developers by creating views and indexes as per their requirements.
• Monitored and optimized query performance using REDGATE Monitoring tool.
• Deployed patches and upgrades on a timely basis to keep up-to-date with latest software releases.
• Configured user accounts, privileges, roles, and profiles in the database server.
• Tested application code changes before deploying them into the production environment.
• Developed scripts for automating routine maintenance tasks, such as index rebuilds and statistics updates.
• Collaborated with network and system administrators to address intricate issues, concurrently dissecting and resolving database and system glitches.
• Ensured database was compliant with legal and regulatory guidelines.
• Collaborated with teams in software development and licensing purchase planning, facilitating seamless implementation.
• Successfully migrated legacy system databases to the latest version of SQL server while preserving data integrity.
• Successfully implemented database migration from on-Premise to Azure and AWS platforms while setting up development, test, and production environments on Azure.
• Implemented and maintained replication, log shipping, as well as Always On to establish a robust, high availability environment for SQL databases.
• Configured security settings at server level, as well as individual user accounts, according to the company's security policy guidelines.

Maintain adherence to all ASOD's policies and procedures regarding database change control management, particularly the Production Release Approval procedure and System Trouble Reporting Procedure.

Responsible for all MSSQL server upgrades and patch installations.

Responsible for all database configuration and performance tuning, conducting the industry's best practices.

Managed database capacity planning, space monitoring, and daily server health checks.

Developed effective MS SQL server backup and recovery scripts to maintain data integrity in Production and DR environment.

Implemented and upheld procedures for standby user databases to support fail-over in a DR/BCP test scenario, adhering to the Bank standard.

Coordinated with application developer/owners for code and content modification, successfully moving files from development to staging environments.

Creating and maintaining the weekly and monthly database maintenance procedures to monitor the health of databases, tables, and indexes.

Implemented ad-hoc data requests and reports using T-SQL scripts, stored procedures, using the PRAS tool.

Maintained effective communication with vendors/customers, Head office's systems support teams, and local ASOD teams as required.

Participated in projects involving database administration and fostered teamwork by working alongside other IT teams.

Assisted in achieving Team's business plans and short-term objectives, identifying and resolving system troubles while recommending countermeasures to prevent failures.

Provide leadership amongst peers in resolving issues in an efficient, effective, and professional manner.

Proficiently handled the installation and configuration of MS-SQL Server in diverse environments (dedicated/shared/cluster) by implementing necessary updates such as service packs and security hot fixes.

Managed the installation process of third-party SQL Server applications, ensuring compliance with BNY standard policies, through close collaboration with approved vendors from BNY and JPMC.

Tested installation and configuration of new SQL Server versions, editions, service packs, and hotfixes. Developed a standardized checklist/documentation for these installations.

Implementing approved vendor patches and DDL to enhance system functionality.

Create and manage database users, local and domain groups, and implement SQL Server Security using Mixed Authentication or Windows Authentication.

Analyzed CPU utilization, memory utilization, and disk utilization using HPOV.

Created and deployed targeted database systems that aligned with organizational objectives.

Configure, monitor, and modify the log shipping setup and transactional replication as per vendor or in-house request.

Expertise in evaluating vendor packages and testing tools, and recommending best business practices.

Collaborated with the Windows Server group to resolve network issues by troubleshooting TCP/IP and protocols, while also responsible for configuring client network utilities.

Administration of clustered SQL servers in 24 x 7 environments, including but not limited to backups, job maintenance, tuning and performance issues, troubleshooting, security issues, service pack patches, and other security patches installation.

Developed strategic plan for information security risk management to meet regulatory requirements and audit recommendations.

Set up the backup jobs and daily/weekly maintenance jobs through Maestro job scheduler.

Migrate databases from test/development to production environment.

Efficiently executed migrations and upgrades of weekly hot fixes and table changes to the UAT/Prod environment, leveraging scripts provided by vendors or in-house application team.

Provided timely completion of ad-hoc data requests and reports for users throughout the enterprise via proficient use of T-SQL scripts, stored procedures, and the Peregrine change control management system.

Worked with content owners to modify code and content. I moved files from development to staging environments and deployed files to production servers, following owner approval.

• Supported planning for software development and purchases and coordinated implementation.
• Defined synchronization plan for patch management.
• Coordinated with development teams to optimize database queries and indexes.
• Managed database security, backup, and recovery procedures to safeguard information.
• Implemented data replication between two different sql Server.
• Provided technical support for developers by creating views and indexes as per their requirements.
• Monitored performance of queries and tuned them as needed using sql profiler tool.