Scotiabank

Senior Database Administrator MSSQL

Scotiabank$90K — $120K *
Information Technology
5 - 7 years of experience
Job Overview by Ladders

Qualifications

  • 5+ years as a MSSQL Database Administrator
  • Experience with MSSQL Server 2016 to 2022
  • Proficiency in Windows Server versions 2016 to 2022
  • Knowledge of GCP Cloud SQL and Azure DB services
  • Familiarity with Active Directory and firewall configurations

Responsibilities

  • Configure and deploy MSSQL servers on public cloud and on-premises
  • Tune performance, plan capacity, and monitor database health
  • Perform database maintenance tasks such as re-indexing and archiving
  • Troubleshoot and resolve MSSQL server and application issues
  • Manage software updates and patches for MSSQL Servers
  • Support disaster recovery and high availability for databases
  • Assist in database projects including installations and migrations

Benefits

  • Commitment to diversity and creating an inclusive culture
  • Access to online courses and tuition assistance for upskilling
  • Competitive reward program that includes flexible vacation options
  • Collaborative work environment with amenities for employee comfort
  • Opportunities to engage with the community through various programs
Full Job Description
Requisition ID: 249794

Reporting to the DBA Manager, the Database Administrator would be supporting the MS SQL Server on-premises as well as on public cloud. As a member of the database administration group, you will assist in the team effort to maximize the availability, security, and performance of the databases.

The Database Administrator is required to work hybrid (on site and work from home) as well as to be on-call for rotational after-hours support of the bank's databases. The Database Administrator must be prepared to provide remote dial-in support, in response to routine monitoring alerts and scheduled & unscheduled maintenance tasks occurring after hours and on weekends.

Is this role right for you? In this role you will:

  • Configuration planning & deploying MSSQL servers/components on public cloud and on-premises servers.
  • Performance tunning, capacity planning and monitoring.
  • Database maintenance/housekeeping including database rebuilds/re-indexing/expansion and archiving.
  • Trouble-shoot MSSQL server problems and assist in the resolution of application problems.
  • MSSQL Server Software currency resolution including Patching/Upgrades/Migrations.
  • Assist in database code promotions & data fixes following internal change control process.
  • Disaster Recovery/High Availability (DR/HA) support with backup, recovery and failover/failback of local and remote replicated databases.
  • Provide DBA support to development/implementation projects as assigned, doing installations, database loading, migrations, testing, and go live support etc.
  • Follow Database best practices, security standards and vulnerability remediations of MSSQL servers and components.
  • Involve in Database related incident management, alerts, and business as usual tasks.


Do you have the skills that will enable you to succeed in this role? We'd love to work with you if you have:

Must have skills
  • At least 5+ years of progressive technical working experience as a MSSQL Database Administrator.
  • MSSQL Server 2022/2019/2017/2016 and prior versions DB Administration
  • Windows Servers 2022/2019/2016 and prior versions.
  • GCP Cloud SQL(MSSQL), GCVE, GCE and Azure MI/DBaaS/IaaS database administration.
  • AD, Firewall IP/Port, domain trust/authentication methods related to MSSQL/Windows database connectivity.


You possess sound practical working experience with:

  • MSSQL Instance/Database Installation/Configuration/Hardening
  • Assist developers on Stored Procedures performance optimization and troubleshooting.
  • Application side tuning vs. server-side tuning.
  • Setup HA/DR with MSSQL Always-On, Availability groups & Database Replication
  • Data Encryption & Masking Data at rest as well as in transit e.g. TDE, SQL Always encryption and TLS etc. configuration
  • Database Re-build/De-fragment techniques
  • Logical & Physical Backup/Recovery/Compression techniques
  • MSSQL Services (SSRS/SSAS/SSIS/Poly base, R Service, Power BI etc.)
  • Scripting and Automation with TSQL, SSIS, Power Shell, C#, VB Scripts etc.
  • You have good analytical, problem solving, trouble shooting and automation skills.


Education and certificationss:
  • Post-secondary education in Computer Science, Math, or related discipline.
  • Microsoft Data Platform and Azure/Google Cloud certification is desired for this role.


What's in it for you?

  • Diversity, Equity, Inclusion & Allyship - We strive to create an inclusive culture where every employee is empowered to reach their fullest potential, respected for who they are, and are embraced through bias-free practices and inclusive values across Scotiabank. We embrace diversity and provide opportunities for all employee to learn, grow & participate through our various Employee Resource Groups (ERGs) that span across diverse gender identities, ethnicity, race, age, ability & veterans.
  • Upskilling through online courses, cross-functional development opportunities, and tuition assistance.
  • Competitive Rewards program including bonus, flexible vacation, personal, sick days and benefits will start on day one.
  • Dynamic Ecosystem - Free tea & coffee, universal washrooms, and lots of space for team collaboration.
  • Community Engagement - We offer opportunities for community engagement & belonging with our various programs!


Location(s): Canada : Ontario : Toronto

About Scotiabank

Scotiabankers are committed to helping individuals, companies, and communities to thrive in a changing world. From personal and business banking, brokerage, and insurance, to private wealth, and the most sophisticated commercial, corporate and institutional services, they serve the diverse needs of some 21 million customers in more than 55 countries. Founded in 1832 in Halifax, Nova Scotia, their growth has always been fuelled by the success of their customers and their longevity secured by an unshakable commitment to carefully and expertly managing risk and capital. That focus on doing what's right for customers—short- andlong-term—has made us a global financial services leader. Headquartered in Canada, they are over 86, 000 Scotiabankers strong. Each of us are committed to being the best at understanding their customers' needs and all of us working together to deliver practical advice and relevant solutions that help their customers become financially better off.

Scotiabank Careers

Join Scotiabank, a premier financial institution, and become part of a diverse and inclusive team that’s leading the way in global banking. At Scotiabank, we offer more than just job opportunities; we provide a platform for professional growth and innovation in the financial services industry.

Work You’ll Do

At Scotiabank, we’re not just filling positions; we’re cultivating leaders. Dive into a workplace where diversity training and leadership development shape the path to your future. Our commitment to professional growth is evident in our robust training programs and continuous learning opportunities that foster innovation and strategic thinking.

Explore a World of Opportunities

Whether you’re looking for a full-time position, an internship, or a leadership role, Scotiabank has a spectrum of opportunities to fit your career ambitions. Our team is composed of individuals who bring a wealth of skills and perspectives to our company, driving us forward with their creativity and strategic insights.

Innovative Work Environment

Scotiabank’s culture is one of collaboration and respect, where each team member’s contribution is valued. Engage in meaningful work that challenges you to leverage your skills and push the boundaries of what’s possible in the banking sector. Our innovative projects not only support the growth of the company but also ensure our position as a leader in the industry.

Benefits and Growth

Choosing a career at Scotiabank means opting for a life of growth and opportunity. Our employees enjoy competitive benefits, including comprehensive health coverage, retirement plans, and flexible working conditions, all designed to support your career and personal life. We believe in nurturing our team’s potential by providing them with the tools they need to succeed both professionally and personally.

Join Our Team

Ready to take the next step in your career? Explore the job opportunities at Scotiabank by searching our open positions that match your skills and interests. We are continuously hiring and looking for passionate, curious, and solution-driven team players.

Networking and Professional Development

Stay connected and advance your career through Scotiabank’s extensive networking opportunities. Participate in events that connect you with other professionals and leaders within the industry. Our career resources will help you prepare your resume, ace your interviews, and land the job that best suits your career goals.

Stay Ahead

Keep up to date with the latest in career tips, industry insights, and company news—all from the people who work here at Scotiabank. Personalize your experience by subscribing to job alert emails tailored to your preferences and be the first to know about new openings and exciting developments. Join Scotiabank and be part of a team that values integrity, respect, and accountability. Discover how your career can flourish in an environment committed to your professional development and personal growth.
Learn more about Scotiabank
Size
90,619 employees
Market Cap
$57.5 billion
Industry
5 Year Trend
+7%
NASDAQ

Similar Jobs

More Jobs at Scotiabank

More Information Technology Jobs

Find similar Senior Database Administrator MSSQL jobs: