Job Description :
SQL Server Developer
Florida City, FL
This Senior SQL Server Database Developer is responsible for end to end database design, development, testing, review, and implementation of code into existing databases for all levels of the Software Development Lifecycle. Additional responsibilities would include troubleshooting, maintenance, and optimization and enhancement of existing data processes. The Senior Database Developer expected to understand and communicate complex processes effectively with team members and internal customers.
Responsibilities:
Provide all database development, maintenance, analysis and support for multiple lines of business
Exhibit the highest level of industry best practice discipline to preserve data integrity, security and availability
Leverage the latest features in SQL Server 2017 to accomplish business goals
Database Development includes
· All SQL Server Reporting Services and SQL Server Integration Services development required to handle business requirements
· All T-SQL database installation, development and maintenance required to implement business requirements
· Develop high complexity, fast performing SELECT queries
· Develop T-SQL DML, procedures, functions, triggers, jobs, scripts, etc.
· Develop Advanced T-SQL such as temporal tables, PIVOTs, recursive table expressions, etc.
· · Database Maintenance (10%) includes (not limited to):
· Database instance installation and upgrade
· Encryption, data access, security permissions and auditing
· Back up, restore and recovery from corruption
· Managing Indexes, statistics, query plans, alerts, database activity and overall performance activity
· Replication and availability groups
· Work independently following all project & support processes in place to complete work assignments
· Utilize Azure DevOps for code management and work assignments using Agile Methodologies
· Create and monitor fault tolerant database jobs across hundreds of integration points
· Identify root causes of data integrity issues and systematically eliminate them