Job Description :
Role: Database Developer/Performance Analyst
Location: Houston, TX
Duration: 12+Months
Skils:
Data Analyst, Database, SQL, SSIS, T-SQL

Job Description:
Hands on and excellence in writing T-SQL complex scripts, stored procedures, database functions, CLR integration, report writing, best practices (optimization, use of joins and sub-queries), design and develop ETL processes utilizing SSIS, complex ETL mappings and other database activities (archive, backups, recovery etc.
Handle data-centric project life cycle development and methodology to plan, design, build, transform, test, store & maintain data on data platform, optimize data-centric projects, increasing awareness of data definitions, maintain consistent data standard across different database systems.
Handle production data systems support - critical applications, day to day tasks/incidents, troubleshooting sensitive data issues, data deployment, change request, monitoring production jobs & data processes, etc.
Troubleshoot and resolve any database related issues (performance/waits/bottlenecks/deadlocks, connectivity, backups, security, AAG, and environment
Assist with managing and monitoring multiple mission critical SQL Server environments, mostly running with SQL Server 2016.
Research & Develop new and improved strategies and processes to help enhance the data environment.
Perform new installations and upgrades to existing SQL Server instances.
Handle tracing the application slowness, identifying root cause and resolving the problem in live system.
Understand schemas, table indexing and statistics, partitioning, query strategies, and database objects maintenance and performance issues.
Maintains database performance by identifying and resolving production and application development problems; evaluating, integrating, and installing new releases; completing maintenance; answering user questions.
Analyze and monitor existing systems capabilities, automate data solutions, implement best practices for data movement across ETL, database/ data warehouse and ensure that the data is adherence to Health care standards, policies, compliance and any external regulations. Working with external data auditors (SOX, Risk Mgt, IT InfoSec) to ensure compliance is met.
Ability to manage individual priorities, coordinate with team members / other departments to address their data/database issues, requirement gathering, drafting technical documents, develop & deploy new data solutions by performing unit, integration, acceptance testing and bug fixing etc.
Monitoring Database and Reporting Server using tools such as AppDynamics, SolarWinds, RedGate or some custom scripts to collect database metrics and come up with a solution to address the problems proactively.
Experience in multi-server data management and database administration functions, Performance tuning in mission critical environments. Perform analysis using execution plans, DMVs, system tables, error logs, etc.
Experience in data-centric project life cycle development and methodology to plan, design, build, transform, test, store & maintain data on data platform, optimize data-centric projects, increasing awareness of data definitions, maintain consistent data standard across different database systems.
Table Partitioning. Source code versioning, SQL Server Integration Services (SSIS) and other equivalent ETL tools and ETL design and development & T-SQL programming using SQL Server