SQL Database Administrator (SQL DBA) Job in Miami, Florida Us
Job Purpose:
Ensures database performance by planning, developing, managing, and securing databases. Provide SQL Server database application life cycle support including database design, development, implementation, and support in the development and production environments. Will manage complex assignments on all instances and databases working in a highly collaborative team environment.
Duties:
* Meets enterprise requirements by planning and developing database structure; developing database utilization policies, procedures, security, backup, and recovery.
* Confirms database requirements by conferring with clients; studying operations and objectives; integrating enterprise requirements; applying database concepts and functional capabilities.
* Maintains design structure by directing implementation of SQL standards and guidelines.
* Completes platform upgrades and migrations by issuing instructions; monitoring performance; coordinating actions.
* Maintains data integrity by establishing standards; monitoring performance.
* Maintains database performance by developing tuning methodologies.
* Provides information by collecting, analyzing, and summarizing database performance and trends.
* Updates job knowledge by participating in educational opportunities; reading professional publications; maintaining personal networks; participating in professional organizations.
* Accomplishes department and organization mission by completing related results as needed.
REQUIRED QUALIFICATIONS AT THIS LEVEL
• Expert support knowledge of SQL Server 2005, 2008 standalone and clustered systems.
• Expert support skills with installing and supporting ODBC, OLEDB RDBMS Clients for SQL Server;
• Ability to write OS Commands;
• Performance/tuning options and tools like Quest PASS
• Familiarity with multiple DBMS, Oracle, DB2, MySQL
• Understand preservation of data integrity (e.g. referential integrity)
• Ensure database availability
• Understand the requirements for differing types of applications (e.g. OLTP vs. Data Warehouse or Reporting)
• Familiar with database design tools like Power Designer