Role-SQL Server DBA Location- Las Vegas, NV Type- ContractRole Description: - The primary objective of the SQL Server Database Administrator (SQL DBA) is to develop and maintain the corporate SQL Server databases ensuring data integrity, security, retention, and recoverability of the data.
- In this role, the DBA will design, build, test, and deploy quality database solutions that are consistent with project objectives, technology architecture standards, and departmental best practices.
- The DBA will design and implement database strategies, administer enterprise-wide data architecture, implement complex data structures, and provide daily management of corporate databases.
- The DBA will create and administer database objects from design to deployment utilizing subject matter expertise to design or re-use, configure, and implement database solutions/processes that maximize system availability, efficiency, effectiveness, integrity, recoverability, and supportability.
Essential Job Functions: - Apply All aspects of database administration including installation, configuration, upgrades, patching, migration, capacity planning, performance tuning, backup, and recovery.
- Work 24x7 rotational on-call support, including driving Root Cause Analysis (RCA), Preventative action follow-through, and participation in weekly operations reviews.
- Change management including maintenance of multiple development, test, QA, and production environments. Responsible for deploying approved changes to production.
- Proactive database monitoring and issue resolution
- Database and T-SQL optimization including performance tuning, query optimization, and supportability.
- Actively participate and contribute to projects involving enterprise database systems enhancements to meet business requirements. Participate in project design and SQL Server database design decisions.
- Develop and implement Database security policies and procedures, in line with corporate objectives
- Responsible for evaluating patch releases and patching requests from development, and communicating constraints, issues, and timelines for deployment.
- Implementation and ongoing support of high availability architecture standards and technologies.
- Create and maintain appropriate documentation about the database and the data architecture.
- Support data management solutions including ETL processing, data archive, data purge, etc.
- Regular proactive capacity planning and tending reviews of all SQL Server databases. Producing weekly, and monthly management reports.
- Work on project sizing processes - including design reviews as necessary to appropriately size new environments, recommend design strategies and deliver associated cost and resource effort estimates.
- Perform other duties as assigned.
Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on the basis of their ability, competence and their proven capability to perform the functions outlined in the corresponding role. We promote and support a diverse workforce across all levels in the company.