girl looking into her desktop
Back to search results

Vice President, Database Admin Consultant – Capital Market, Chief Technology Organization

Singapore, , Singapore

Job Description:

Your background

  • In-depth knowledge of Microsoft SQL Server Instances, Database administration and SQL Server components such as Database engine(SSDS), Integration Services(SSIS), Reporting Services(SSRS) and Analysis Services(SSAS) running on Windows Standalone and Cluster servers
  • Strong understanding and/or working experience of Microsoft SQL Server installation, upgrade, database setup and implementation of SQL Server technologies such as SQLAlwaysOn, Database Mirroring, Log Shipping, SQL Replication and Windows Standalone\Clusterring using Storage-level replication for High availability and Disaster recovery
  • Solid years of experience at least 5-8 years of Banking or Financial institution as SQL Server DBA Level 2 or 3 role
  • Experience in SQL Server Instance upgrade from SQL Server lower version to latest version and Database migration from one SQL Server to another
  • Strong knowledge in utilizing SQL Server monitoring and troubleshooting\performance tools such SQLCMD, SQL profiler, Database Import/Export, Database upgrade tool and SQL Server Management Studio
  • Experience in addressing SQL database alerts/issues, capacity constraints and performance related items
  • Demonstrated ability in problem solving, identify tuning opportunities, implement improvement and advise Production support\developer teams on root cause/analysis, SQL tuning and permanent solution
  • Experience in MS Dos/Powershell scripting and able to write Transact SQL scripting will be plus.

What you can expect

The APAC SQL Server Database Team is part of the wider Application & Database Services Organization that spans the globe. We have on site personnel in all 3 regions, AMRS, EMEA and APAC, supporting the all Lines of Business within the bank. As part of the global organization, we design, build and operationally support Microsoft SQL Server Instances and Database Administrations in Non-DBAAS & DBAAS platform which runs on Microsoft Windows Servers using Physical and Virtual machines.

As part of this role, you will get to work on, responsible and gain exposure to the following:

  • Microsoft SQL Server 2008/2012/2014/2016 and 2019 Instances and Databases
  • Microsoft SQL Server Components such as Database Engine(SSDS), Integration Services(SSIS), Reporting Services(SSRS) and Analysis Services(SSAS)
  • Microsoft SQL Servers using Physical and Virtual Machines hosted on Microsoft Windows Servers(2008/2012/2016)
  • Microsoft SQL Server technologies such as SQL Alwayson(AG), Database Mirroring, Transaction Log Shipping,SQL Server Replication and Windows Standalone\Clustering using Storage-level replication
  • Install, configure, upgrades, applying patches to Microsoft SQL Server Instances using BMC Bladelogic Database Automation Tools(BDA) and BOFA cloud services
  • Troubleshooting, Database performance and tuning, Availability monitoring using Quest Foglight
  • Creation, maintenance, monitoring and implementation of SQL Server Databases routines such as Database Integrity checks, Rebuild and Reorganize index, Update Statistics, Database backup and restore operation
  • Implement Microsoft SQL Server Database features such as Compression, Encryption, Link Servers, Management Data Warehouse(MDW) and Partitioning
  • Exposure to Logical and Physical Database design and implementation
  • Triage database outage, troubleshooting and performance tuning issues.
  • High level system knowledge on Microsoft Windows Servers on Standalone and Clusters, ESX servers, EMC Storage & BoFA Cloud services.
  • Automation of Database routines such as writing and maintaining scripts using Stored procedures, Function, Transact-Query statement and Windows Powershell scripting
  • Administration activities for SQL Server and Database level security (creating logins, roles and users)
  • Worked on Database backup, restore and SQL job scheduling using SQL Agent, Autosys jobs and Veritas NetBackup software

What you will do

  • Position entails all aspects of Microsoft SQL Server Instance and Database administration, backup and recovery, designing for high availability, disaster recovery and replication, performance monitoring-tuning, scripting, software installation and upgrades, troubleshooting, and proactively maintaining production databases.
  • Manages multiple, moderately complex projects and direct activities of a team related to special initiatives or operations.
  • Identify, troubleshoot, resolve, and communicate issues that affect the systems, servers and database related products
  • Create and maintain SQL profiler template and PSSDIAG used to monitor and capture slow\offending query by the application and if required, worked with Microsoft Engineer team to perform analysis and root cause investigation
  • Partner with other Operation teams to maximize availability in current and planned systems and implement new technologies in the Bank.
  • Handle Application team, MAPS\Support team and Dev Team questions, request, incidents, monitoring and escalating as appropriate
  • Assigned as Application DBA\Subject Matter Expert(SME) for Application team
  • Administer and implement on Microsoft SQL Server Instances and Database automation tools used in the Bank such as Datical(for SQL Script release), ART(SQL Database failover\failback) and Optim(Data archiving solution)
  • Administer SQL Server logins, database users and database security in accordance with mandatory enterprise wide guidelines.

About Bank of America

Our purpose as a firm is to make financial lives better, through the power of every connection. Across the world, we partner with leading corporate and institutional investors through our offices in more than 35 countries. In the U.S. alone, we serve almost all of the Fortune 500 companies and approximately 67 million consumer and small-business clients. We provide a full suite of financial products and services, from banking and investments to asset and risk management. We cover a broad range of asset classes, making us a global leader in corporate and investment banking, sales and trading.

Connecting Asia Pacific to the world

Our Asia Pacific team is spread across 19 cities in 12 markets. We are focused on connecting Asia to the world and the world to Asia, using our global expertise to ensure success is shared between us, our clients and our communities. Our regional footprint covers 12 currencies, more than a dozen languages and five time zones, placing us firmly among the region’s leading financial services companies.

Job Band:

H5

Shift: 

Hours Per Week:

40

Weekly Schedule:

Referral Bonus Amount:

0

Job Description:

Your background

  • In-depth knowledge of Microsoft SQL Server Instances, Database administration and SQL Server components such as Database engine(SSDS), Integration Services(SSIS), Reporting Services(SSRS) and Analysis Services(SSAS) running on Windows Standalone and Cluster servers
  • Strong understanding and/or working experience of Microsoft SQL Server installation, upgrade, database setup and implementation of SQL Server technologies such as SQLAlwaysOn, Database Mirroring, Log Shipping, SQL Replication and Windows Standalone\Clusterring using Storage-level replication for High availability and Disaster recovery
  • Solid years of experience at least 5-8 years of Banking or Financial institution as SQL Server DBA Level 2 or 3 role
  • Experience in SQL Server Instance upgrade from SQL Server lower version to latest version and Database migration from one SQL Server to another
  • Strong knowledge in utilizing SQL Server monitoring and troubleshooting\performance tools such SQLCMD, SQL profiler, Database Import/Export, Database upgrade tool and SQL Server Management Studio
  • Experience in addressing SQL database alerts/issues, capacity constraints and performance related items
  • Demonstrated ability in problem solving, identify tuning opportunities, implement improvement and advise Production support\developer teams on root cause/analysis, SQL tuning and permanent solution
  • Experience in MS Dos/Powershell scripting and able to write Transact SQL scripting will be plus.

What you can expect

The APAC SQL Server Database Team is part of the wider Application & Database Services Organization that spans the globe. We have on site personnel in all 3 regions, AMRS, EMEA and APAC, supporting the all Lines of Business within the bank. As part of the global organization, we design, build and operationally support Microsoft SQL Server Instances and Database Administrations in Non-DBAAS & DBAAS platform which runs on Microsoft Windows Servers using Physical and Virtual machines.

As part of this role, you will get to work on, responsible and gain exposure to the following:

  • Microsoft SQL Server 2008/2012/2014/2016 and 2019 Instances and Databases
  • Microsoft SQL Server Components such as Database Engine(SSDS), Integration Services(SSIS), Reporting Services(SSRS) and Analysis Services(SSAS)
  • Microsoft SQL Servers using Physical and Virtual Machines hosted on Microsoft Windows Servers(2008/2012/2016)
  • Microsoft SQL Server technologies such as SQL Alwayson(AG), Database Mirroring, Transaction Log Shipping,SQL Server Replication and Windows Standalone\Clustering using Storage-level replication
  • Install, configure, upgrades, applying patches to Microsoft SQL Server Instances using BMC Bladelogic Database Automation Tools(BDA) and BOFA cloud services
  • Troubleshooting, Database performance and tuning, Availability monitoring using Quest Foglight
  • Creation, maintenance, monitoring and implementation of SQL Server Databases routines such as Database Integrity checks, Rebuild and Reorganize index, Update Statistics, Database backup and restore operation
  • Implement Microsoft SQL Server Database features such as Compression, Encryption, Link Servers, Management Data Warehouse(MDW) and Partitioning
  • Exposure to Logical and Physical Database design and implementation
  • Triage database outage, troubleshooting and performance tuning issues.
  • High level system knowledge on Microsoft Windows Servers on Standalone and Clusters, ESX servers, EMC Storage & BoFA Cloud services.
  • Automation of Database routines such as writing and maintaining scripts using Stored procedures, Function, Transact-Query statement and Windows Powershell scripting
  • Administration activities for SQL Server and Database level security (creating logins, roles and users)
  • Worked on Database backup, restore and SQL job scheduling using SQL Agent, Autosys jobs and Veritas NetBackup software

What you will do

  • Position entails all aspects of Microsoft SQL Server Instance and Database administration, backup and recovery, designing for high availability, disaster recovery and replication, performance monitoring-tuning, scripting, software installation and upgrades, troubleshooting, and proactively maintaining production databases.
  • Manages multiple, moderately complex projects and direct activities of a team related to special initiatives or operations.
  • Identify, troubleshoot, resolve, and communicate issues that affect the systems, servers and database related products
  • Create and maintain SQL profiler template and PSSDIAG used to monitor and capture slow\offending query by the application and if required, worked with Microsoft Engineer team to perform analysis and root cause investigation
  • Partner with other Operation teams to maximize availability in current and planned systems and implement new technologies in the Bank.
  • Handle Application team, MAPS\Support team and Dev Team questions, request, incidents, monitoring and escalating as appropriate
  • Assigned as Application DBA\Subject Matter Expert(SME) for Application team
  • Administer and implement on Microsoft SQL Server Instances and Database automation tools used in the Bank such as Datical(for SQL Script release), ART(SQL Database failover\failback) and Optim(Data archiving solution)
  • Administer SQL Server logins, database users and database security in accordance with mandatory enterprise wide guidelines.

About Bank of America

Our purpose as a firm is to make financial lives better, through the power of every connection. Across the world, we partner with leading corporate and institutional investors through our offices in more than 35 countries. In the U.S. alone, we serve almost all of the Fortune 500 companies and approximately 67 million consumer and small-business clients. We provide a full suite of financial products and services, from banking and investments to asset and risk management. We cover a broad range of asset classes, making us a global leader in corporate and investment banking, sales and trading.

Connecting Asia Pacific to the world

Our Asia Pacific team is spread across 19 cities in 12 markets. We are focused on connecting Asia to the world and the world to Asia, using our global expertise to ensure success is shared between us, our clients and our communities. Our regional footprint covers 12 currencies, more than a dozen languages and five time zones, placing us firmly among the region’s leading financial services companies.

Learn more about this role

Full time

JR-21051333

Band: H5

Manages People:

Manager:

Talent Acquisition Contact:

Marion Cecile Gouilly (グイー マリオン セシル)

Referral Bonus:

0

Street Address

Primary Location:
2 HARBOURFRONT PLACE, #02-01, Singapore, 098499