DBA Senior Consultant

Job Title: Database AdministratorDesignation: DBA Technical Associate

The Senior Database Administrator is responsible for maintaining the ISNetworld SQL Servers (both virtual machine-based and cloud-based) and databases, ensuring database availability and uptime for both high availability and disaster recovery, leading migration efforts related to moving IaaS-based workloads and systems into PaaS/SaaS equivalent, helping ISN’s products development teams with source control and both manual and automated deployments for SQL code, and maintaining uptime for the ISNetworld environments. This position is a service-oriented role and requires a high sense of ownership of problems, with a focus on managing and resolving issues in alignment with SOPs, security, and uptime requirements, as well as maintaining communication with multiple teams to keep them updated regarding the status of any open tasks or items, escalations, and any solutions proposed/implemented. The position will also expose individuals to the complete Software Development Life Cycle.

• Maintain, monitor, and manage the SQL Server databases in all ISNetworld environments
  • Troubleshoot performance and availability issues related to Windows Server, SQL Server on Virtual Machines, Azure SQL Server Managed Instances, Always On Readable Secondaries, Always On Availability Groups, SQL Service Broker, and SQL replication
  • Continuously monitor and baseline SQL Server databases, performance, security, and changes
  • Proactively and reactively resolve database performance and capacity issues, including managing indexes, statistics, SQL trace data, audits, and ing
  • Manage SQL Server jobs and Windows scheduled tasks, including synchronizing across multiple instances
  • Manage and monitor SQL Database Mail end-to-end
  • Perform cumulative updates, migrate and upgrade SQL Server versions as needed for IaaS (Virtual Machine) deployments
  • Lead efforts to migrate IaaS (Virtual Machine) workloads built on/in SQL Server to PaaS/SaaS
  • Automate routine tasks, response using Powershell, SQL, .NET, or other tools (e.g., dbatools)
  • Analyze query execution plans and advise developers on best practices for database code
  • Collaborate with development, QA, and business teams, and at times, directly with customers
  • Manage data access and security of SQL Server databases and critical ISNetworld data
  • Support team members for requests with Azure Data Factory, Integration Services (SSIS), and other data import/export tools
  • Proactively analyze and bring forth ideas for continuous improvement, including researching and developing new ways to improve existing functionality and increase uptime and performance
  • Assist other Technical Operations team members in maintaining application and website uptime, including managing Windows Server, DNS, patching systems, etc. when needed

SQL DBA experience

·5+ years of experience in Microsoft SQL Server Database Administration on SQL Server 2016+

·1+ years of experience managing SQL Servers running on Microsoft Azure virtual machines

High Availability

·Clustering: 2+ years managing SQL Server clusters in a Production environment

·Always On: 2+ years managing SQL Server Always On availability groups in a Production environment

SQL Features

·Replication: 2+ years managing SQL Server Transactional Replication

SQL Install, Configure

·Strong knowledge of storage fundamentals related to SQL Server

·Experience patching/upgrading SQL Servers in a Production Always on Environment

Troubleshooting

·Experience using SQL Trace, SQL Profiler to identify issues

·Strong knowledge of troubleshooting techniques using logs, execution plans, Query Store, DMVs

Programming

·Experience in T-SQL queries, stored procedures, functions (don’t need a “SQL developer” but do need to be able to work with developers to assist troubleshooting performance)

Experience in PowerShell for managing SQL Server, automation

• Experience with SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).
• Knowledge of cloud database solutions and services.
• Familiarity with database monitoring tools and performance analysis software.
• Understanding of data warehousing concepts and ETL processes.
• Experience with other database management systems (e.g., MySQL, Oracle) is a plus.

• Bachelor's degree in Computer Science, Information Technology, or a related field.
• Relevant certifications in SQL Server or database management are advantageous.
• Strong analytical and problem-solving skills.
• Excellent communication and interpersonal skills.
• Ability to work independently and as part of a team in a fast-paced environment.

Mphasis applies next-generation technology to help enterprises transform businesses globally. Customer centricity is foundational to Mphasis and is reflected in the Mphasis’ Front2Back™ Transformation approach. Front2Back™ uses the exponential power of cloud and cognitive to provide hyper-personalized (C=X2C2TM=1) digital experience to clients and their end customers. Mphasis’ Service Transformation approach helps ‘shrink the core’ through the application of digital technologies across legacy environments within an enterprise, enabling businesses to stay ahead in a changing world. Mphasis’ core reference architectures and tools, speed and innovation with domain expertise and specialization are key to building strong relationships with marquee clients.

Mphasis is an equal opportunity/affirmative action employer. We provide equal employment opportunities to applicants and existing associates and evaluate qualified candidates without regard to race, gender, national origin, ancestry, age, color, religious creed, marital status, genetic information, sexual orientation, gender identity, gender expression, sex (including pregnancy, breast feeding and related medical conditions), mental or physical disability, medical conditions military and veteran status or any other status or condition protected by applicable federal, state, or local laws, governmental regulations and executive orders. View the EEO in the law poster here, view the EEO in the law supplement here. To view the pay transparency nondiscrimination provision please click here and to view the E-Verify posting click here.
Mphasis is committed to providing reasonable accommodations to individuals with disabilities.