What are the responsibilities and job description for the SQL Database Administrator /SQL Developer position at EXOS (formerly Sondhi Solutions)?
Role Description:
* Database Administrator and SQL developer with 7 years of experience and expert-level skill in development, analysis, architecture, design, installation, configuration, operation, and maintenance of information systems hardware and software.
* Expert-level skill and knowledge and experience in DDL, DML, Physical and Logical Data Modeling (w/UML), Stored Procedures, DB Index Management, Normalization and de-normalization, Data replication, Reporting, ETL, database design, development, and administration-related concepts, methods, and tools
* Expert-level skill and knowledge and experience in Data Warehouse concepts, including data mining, data marts, on-line analytical processing (OLAP), etc.
* Expert-level skill and knowledge and experience in Microsoft SQL Server, Business Intelligence Solutions, SQL Server Monitoring/Performance tools, Database security and integrity
* Resolve database performance and capacity issues, and replication and other distributed data issues.
* Determine and implement appropriate change management policies and processes.
* Install, configure, test/benchmark, and maintain the general health of database servers and related infrastructure, monitor system logs for alerts, errors and warnings, and available/free space on the OS and storage volumes, and analyze space usage history and recommend changes as needed.
* Create/update documentation for new/existing maintenance and installation processes.
* Advanced T-SQL, PowerShell skills.
* Deep familiarity with SQL Server tools, e.g. SSMS, SQL Profiler, Database Tuning Advisor, SQL Server Configuration Manager, DMVs, Extended Events, etc.
* Proven database maintenance skills (backups, index defragmentation, database integrity checks).
* Execute ETL tasks in support of data loads.
* Troubleshoot and resolve issues.
* Experience with High Availability (HA) and Disaster Recovery (DR) options for SQL Server
* Database Administrator and SQL developer with 7 years of experience and expert-level skill in development, analysis, architecture, design, installation, configuration, operation, and maintenance of information systems hardware and software.
* Expert-level skill and knowledge and experience in DDL, DML, Physical and Logical Data Modeling (w/UML), Stored Procedures, DB Index Management, Normalization and de-normalization, Data replication, Reporting, ETL, database design, development, and administration-related concepts, methods, and tools
* Expert-level skill and knowledge and experience in Data Warehouse concepts, including data mining, data marts, on-line analytical processing (OLAP), etc.
* Expert-level skill and knowledge and experience in Microsoft SQL Server, Business Intelligence Solutions, SQL Server Monitoring/Performance tools, Database security and integrity
* Resolve database performance and capacity issues, and replication and other distributed data issues.
* Determine and implement appropriate change management policies and processes.
* Install, configure, test/benchmark, and maintain the general health of database servers and related infrastructure, monitor system logs for alerts, errors and warnings, and available/free space on the OS and storage volumes, and analyze space usage history and recommend changes as needed.
* Create/update documentation for new/existing maintenance and installation processes.
* Advanced T-SQL, PowerShell skills.
* Deep familiarity with SQL Server tools, e.g. SSMS, SQL Profiler, Database Tuning Advisor, SQL Server Configuration Manager, DMVs, Extended Events, etc.
* Proven database maintenance skills (backups, index defragmentation, database integrity checks).
* Execute ETL tasks in support of data loads.
* Troubleshoot and resolve issues.
* Experience with High Availability (HA) and Disaster Recovery (DR) options for SQL Server
Salary : $40 - $50
