DUTIES AND RESPONSIBILITIES
Implement, upgrade and enhance cost-effective fault-tolerant database infrastructure
Analyze system performance. Establish and uphold performance metrics for the system as whole and key business applications in particular.
Fine-tune the databases to match application requirements.
Provide database support and maintenance. Support user’s requests in relation to system problems and requests for enhancements.
Ensure systems uptime
Design indexes for existing applications, choosing when to add or remove indexes
When users complain about the performance of a particular query, help developers improve the performance of that query by tweaking it or modifying indexes
Recommends solutions by defining database physical structure and functional capabilities, database security, data back-
up, and recovery specification
communicating regularly with technical, applications and operational staff to ensure database integrity and security
Support software projects involving the database infrastructure which this person supports.
Additional responsibilities :
Ensures the effective fulfillment of objectives and deadlines assigned to the group.
Comply with all safety policies, practices and procedures. Report all unsafe activities to supervisor and / or Human Resources.
Participate in proactive team efforts to achieve departmental and company goals.
Perform other duties as assigned.
Other duties may be assigned.
The requirements listed below are representative of the knowledge, skill, and / or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
EDUCATION and / or EXPERIENCE
Ideally System Engineer degree or related field.
Solid background in Microsoft SQL and in a clustered, adhoc SQL queries, log shipping and store procedures is a plus
Ideally between 3-7 years’ experience as a DBA in a fast paced, high growth, technology and intensive environment.
Solid background in Postgres DB is plus
Ideally, strong understanding of Linux operating system and ability to navigate the operating system
Solid background of SQL Server native / SharePoint integrated reporting services administration, reporting services security, configuration and report deployment.
Solid background in Microsoft SQL Server / Analysis services in a clustered environment
Solid background in Windows server administration, Analysis Services, Integration Services, or Reporting Services.
Certifications from Microsoft in current versions of SQL a positive is a plus
We are an equal opportunity employer. All applicants will be considered for employment without attention to race, color, religion, sex, sexual orientation, gender identity, national origin, veteran or disability status.
We also respect your privacy. Our Applicant Privacy Policies can be found here : http : / / jobs.jobvite.com / align-tech /