Job Description
Experienced Chennai Posted 3 mins ago Responsibilities: Define and build overall data design and modeling across all of the organizations data systems. Data management across multiple data systems: data governance, data mastering, meta-data management, data definitions, symantec-layer design, data taxonomies and ontologies. Architecting and delivering highly-scalable and flexible, cost-effective enterprise data solutions. Anticipate future technology requirements and communicate those to the leadership and multi-functional teams. Understand the current state of the organization-wide architecture. Identify key business drivers and technology capabilities required to achieve optimal state. Coordinate with collaborator teams and own the conversation to define use cases, goals, objectives, and architecture to support the business needs. Years of Experience: 5 8 Years Designation: Senior Database Analyst Required Skills: Bachelors in Computer Science Engineering. with minimum 5 years of experience, out of which 2 years of solid work experience in Microservice. Strong experience in Database Administration in SQL Server ( 2008 R2, 2016 and 2017) and Manage Cloud Based SQ Server (AWS/AZURE RDS). Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc. Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools. Ability to detect and troubleshoot SQL Server related CPU, memory, I/O, disk space and other resource contention. Strong knowledge of backups, restores, recovery models, database shrink operations, DBCC commands, Clustering, Database mirroring, Replication. Expert experience in implementing operational automation. Strong knowledge of how indexes, index management, integrity checks, configuration, patching. How statistics work, how indexes are stored, how they can be created and managed effectively. Knowledge of SQL Server tools (Profiler, DTA, SSMS, SAC, SSCM, PerfMon, DMVs, system sprocs) SQL Development ability to write and troubleshoot SQL Code and design (storedprocs, functions, tables, views, triggers, indexes, constraints) Solid acquaintance with windows server, security delegation, SPNs, storage components. About the Company: SolvEdge is a company building cutting edge software products for the healthcare industry. Re-imagining healthcare delivery for our clients across the globe, our history of simplifying healthcare goes way back to 2004. Today, SolvEdge is trusted by a broad spectrum of clients including 450+ Hospitals, 3500+ Physician Practices and millions of Patients by solving their most complex challenges and helping them deliver consistent, cohesive and collaborative care. SolvEdge is headquartered in Chicago, U.S with its R&D and delivery center in Chennai, India. Job Features Job Category Developer
Employement Category:
Employement Type: Full time
Industry: Financial Services
Role Category: DBA / DatawarehousingApplication Programming / Maintenance
Functional Area: Not Applicable
Role/Responsibilies: Senior Database Analyst
Keyskills:
Database Administration
SQL Server
Performance Tuning
Query Optimization
Clustering
Database Mirroring
Replication
SQL Development
Windows Server
Microservice
Backups
Restores
Recovery Models
Operational Automation
Indexes
Security Delegation
SPNs
Storage Components