SUMMARY
Database Administrator is responsible for maintaining, configuring, and performance tuning database systems. The current platforms that need to be supported are MS SQL Server 2019 and 2022, as well as Oracle 19c. The primary duties include correcting issues in real time, ensuring performance, availability, security, monitoring the health of all internally hosted database server supported by the IT Production Support area.
JOB FUNCTIONS/DUTIES AND RESPONSIBILITIES
- Monitors daily processing, research exceptions and request items
- Monitors database performance and performs database tuning
- Establishes and monitors database backup, recovery, and replication processes
- Participates in disaster recovery testing for databases in conjunction with the Business Continuity Team
- Establishes database access controls under the supervision of the Security Administrator
- Designs and creates databases for applications developed by the bank implementing bank standards
- Performs data masking of production data prior to restoring data in lower development, test environments
- Designs and writes stored procedures in SQL
- Review and deploy (database objects) to various environments ensuring bank defined database best practices are adhered to.
- Adheres to bank policy regarding change management
- Be part of the L2 production support team supporting internal and vendor applications.
- Be able to analyze a situation, communicate the issue to clients and management in a clear and concise manner.
- Installs, upgrades, and patches both MS SQL Server and Oracle databases with ASM running on Linux (weekend maintenance activities)
- Working knowledge in database systems architecture, including networking, security, scaling, and fault-tolerance.
- Working knowledge of database internals such as locking, wait events, consistency, logging, recovery.
- Enhances knowledge and understanding of job responsibilities through continuous communication and on the job training. Training should focus on establishing high quality/accuracy of work.
- Participate in the on-call rotation of the Production Support group
- Provides high quality work by ensuring accuracy and seeking to continuously improve our processes and platforms by embracing new and better ways of doing things.
REQUIREMENTS
- Bachelor’s degree in Computer Science or equivalent
- 5+ years of DBA experience on Windows for Microsoft SQL and Linux with Oracle experience.
- Ability to work with Windows, UNIX, and Linux operating systems
- Knowledge of SQL, Transact SQL, PL-SQL
- Knowledge of PowerShell or other scripting languages
- Experience with version control system
- Experience with replication services such as SQL always-on, Doubletake, and AWS DRS is a plus
- Working knowledge of MS SQL Server native auditing
- Experience with database monitoring tools - Solarwinds DPA, or Idera Diagnostic Manager a plus
- Experience with DataMasker tool for masking databases is a plus
- Excellent problem analysis and resolution skills.
- Excellent interpersonal skills.
- Excellent oral and written communication skills in English.
- Ability to work independently in a decentralized environment, without the reliance of direct authority.
- Proven maturity, reliability, composure, and stability under pressure.
- Strong organizational, analytical, and planning skills; Attention to detail and the ability to prioritize multiple, competing responsibilities
- Experience working directly with internal and/or external customers in database software development, release deployment, and support.
PHYSICAL DEMANDS
None
Why you should join :
We embrace flexible ways of working when business and role permits. We provide employees with a hybrid working model, allowing for in-office work and work from home. Our diverse and inclusive environment along with our global presence enables us to collaborate and communicate to meet our business needs. We believe that efficient teams need truth, loyalty, and a strong sense of purpose to balance risk and their targets. We believe that each person brings a unique value that drives the business through their creativity and passion.
The Employee Benefits package includes: Paid Time Off, medical, HSA, vision, dental, FSA, 401(k), profit sharing, legal plan, cancer indemnity plan, disability insurance, life insurance, employee assistance program, commuter benefits, business travel accident, paid volunteer day, paid memberships, paid seminars, and tuition assistance.
We offer many socialization opportunities for wellness, financial wellbeing, runs/walks, team building, and activities to support the Sustainable Developmental Goals.
We are an equal employment opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, national origin, disability status, protected veteran status or any other characteristic protected by law. The Bank provides reasonable accommodation for employees and applicants with disabilities consistent with applicable law. If you need reasonable accommodation during the application, please contact us.
