What are the responsibilities and job description for the Database Administrator position at RightTalents?
Job Details
Title: Database Administrator
Location: Brooklyn, NY (Onsite)
Duration: 36 Months
Work Hours: 40hrs/week
Tasks & Duties
Implement conceptual design to physical database implementation, enhance and refine the logical design of the database.
Monitor and manage SQL Servers and databases on a day-to-day basis; develop database designs, stored procedures, triggers, and constraints for new applications in MS SQL Server based on client standards.
Provide day-to-day advice to users on data structures and terminology and develop policies and procedures related to the support and maintenance of database applications.
Monitor databases for optimal performance and act to mitigate blocking and performance tuning issues.
Provide guidance to Application Development staff for query, stored procedures, functions, and database design.
Baseline system performance and monitor for deviations, recommending and implementing improvements to slow-running queries.
Document database architecture, configuration settings, baseline performance metrics, and planned and unplanned outages.
Establish and implement best practices regarding data definition, data quality, data security, and data integration.
Perform database administration duties, including installation, patching, backup and recovery management, space management, schema management, startup, and shutdown.
