The Associate MSSQL Server Database Administrator role is largely responsible for providing operational database services to the organization. Some of the primary responsibilities of this role would include owning, tracking and resolving database related incidents and requests, fulfilling requests and resolving incidents within SLAs, reviewing service related reports (e.g.: database backups, disk reports, maintenance, monitoring) on a daily basis to ensure service related issues are identified and resolved within established SLAs, responding to database related alerts and escalations and working with other colleagues in Engineering to come up with strategic solutions to recurring problems.
This MSSQL Server DBA role requires a service oriented mentality, high sense of ownership of the problems and requests assigned, focus on managing and resolving issues in alignment with the SLAs, establishing and maintaining communication within the entire Engineering team and with internal and external customers to keep them updated with status of their requests, initiating and performing changes on production systems and proactively escalating any issues that cannot be resolved within the established timeframes.
MINIMUM QUALIFICATIONS AND REQUIREMENTS:
2-3 years of experience with SQL database administration experience; MSSQL 2012, 2014 or 2016 preferred.
Bachelor’s in related degree field is required.
Ability to create and follow written procedures.
Experience in troubleshooting and resolving database problems.
Ability to independently learn new technologies through research and vendor provided documentation.
Ability to work independently and proactively with a minimum of supervision.
Experience in implementing operational automation (SQL maintenance or backup jobs).
Experience in setting up multiple data replication techniques such as Snapshot, Transactional or Merge
Experienced in setting up Clustered databases and Always-On Availability Groups
Knowledge of indexes, index management, and statistics.
Experience with setting up, administering and troubleshooting SSRS.
Experience working with Windows server, including Active Directory and proper disk configurations.
Understanding of Storage Area Network concepts and technologies (with respect to SQL Server).
Good communication and documentation skills.
Involvement with the MSSQL Server Community; membership in PASS, active in forums or newsgroups.
Certification is a plus: MTA, MCSA, MCSE
PRINCIPAL DUTIES AND RESPONSIBILITIES:
Assists in planning, implementing and maintaining a production MSSQL database server environment.
Supports a robust security program by following best practices related to the database server environment.
Participates in rotating schedule that requires on-call availability 24x7 during scheduled period.
Responds to database-oriented engineering requests.
Researches new database-related technologies and can provide a spoken presentation or training session to Engineering and IT Operations team.
Maintains system performance by performing system monitoring and analysis, and performance tuning; troubleshooting system hardware, software, networks and operating and system management systems; designing and running system load/stress testing; escalating application problems to vendors
Performs system upgrades in collaboration with operation staff and external service providers as needed.
Updates job knowledge by participating in educational opportunities; reading professional publications; maintaining personal networks; participating in professional organizations.
Other duties may be assigned, as required