• Snapboard
  • Activity
  • Reports
  • Campaign
Welcome ,

Chat with the recruiter

...Minimize

Hey I'm Online! Leave me a message.
Let me know if you have any questions.

Infrastucture Engineer

In Ohio / United States

Save this job

Infrastucture Engineer   

Click on the below icons to share this job to Linkedin, Twitter!

JOB TITLE:

Infrastucture Engineer

JOB TYPE:

JOB SKILLS:

JOB LOCATION:

Columbus Ohio / United States

JOB DESCRIPTION:

The Infrastructure Engineer (DBA) position will be responsible for maintaining the database systems including back-up, performance tuning, capacity planning, monitoring critical events and documentation Serves as systems administrator for enterprise applications by:

Monitor, maintain database systems and troubleshoot problems that may arise. Maintain data integrity and security (manage roles and permissions of database users). Use tools like SQL Profiler for database tuning. Generate traces, execution plans, identify performance issues, deadlocks/contention and resolve them. Develop strategies and implement solutions for managing back-ups, restoration and replication. Create and manage constraints and indexes. Support software developers with database operations including the development of complex SQL, tuning of DML and the creation of stored procedures. Proactive housekeeping/archiving and shrinking of databases. Manage production, QA and development database environments. Implement appropriate indexes (B-Tree, Geospatial, Text) for performance improvement.

Create detailed documentation including diagrams of database infrastructure. Learn relevant business processes and understand the data flow, criticality and dependencies. Effectively coordinate and communicate with all the stakeholders (internal teams and clients). Analysis and development of enhancements to meet changing user requirements Execution of change control procedures to ensure all enhancements, upgrades and patches are thoroughly tested and planned before implementation in the production environment

Maintaining all related technical documentation; where applicable, developing and communicating company policies and procedures Regularly solicit feedback and Hosted Applications requirements from customers and end-users


Required Skills : Bachelors or Master's degree in computer science or equivalent education and experience. 6 - 10 years experience in administering Microsoft SQL server databases. Extensive experience writing T-SQL and stored procedures and query tuning on high transaction systems. Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server Knowledge in DB2, MongoDB, PostgreSQL, Hadoop and database instances in Azure/AWS would be a plus Experienced in SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS). Experienced in ETL (Extract-Transform-Load) development / data integration. Sound knowledge of RDBMS concepts, database architecture and SQL/T-SQL. Proficient with SQL server profiler for monitoring and troubleshooting database activity and performance. Experience in SQL Server Clustering and HA technologies including mirroring, log shipping, failover cluster and various replication technologies would be an advantage. Knowledge of other databases like MySQL, No SQL databases and In-memory databases and MCTIP certification will be an advantage. Ability to develop procedure documents and maintain detailed database related documents. Innovative approach to work, constantly looking for upgrading the system to more efficient and effective new technologies.
Basic Qualification :
Additional Skills :
Rank :A3
Requested Date :2021-03-30

Position Details

POSTED:

Jul 08, 2021

EMPLOYMENT:

INDUSTRY:

SNAPRECRUIT ID:

S16174659016881359

LOCATION:

Ohio / United States

CITY:

Columbus

Job Origin:

CEIPAL_ORGANIC_FEED

A job sourcing event
In Dallas Fort Worth
Aug 19, 2017 9am-6pm
All job seekers welcome!

Infrastucture Engineer    Apply

Click on the below icons to share this job to Linkedin, Twitter!

The Infrastructure Engineer (DBA) position will be responsible for maintaining the database systems including back-up, performance tuning, capacity planning, monitoring critical events and documentation Serves as systems administrator for enterprise applications by:

Monitor, maintain database systems and troubleshoot problems that may arise. Maintain data integrity and security (manage roles and permissions of database users). Use tools like SQL Profiler for database tuning. Generate traces, execution plans, identify performance issues, deadlocks/contention and resolve them. Develop strategies and implement solutions for managing back-ups, restoration and replication. Create and manage constraints and indexes. Support software developers with database operations including the development of complex SQL, tuning of DML and the creation of stored procedures. Proactive housekeeping/archiving and shrinking of databases. Manage production, QA and development database environments. Implement appropriate indexes (B-Tree, Geospatial, Text) for performance improvement.

Create detailed documentation including diagrams of database infrastructure. Learn relevant business processes and understand the data flow, criticality and dependencies. Effectively coordinate and communicate with all the stakeholders (internal teams and clients). Analysis and development of enhancements to meet changing user requirements Execution of change control procedures to ensure all enhancements, upgrades and patches are thoroughly tested and planned before implementation in the production environment

Maintaining all related technical documentation; where applicable, developing and communicating company policies and procedures Regularly solicit feedback and Hosted Applications requirements from customers and end-users


Required Skills : Bachelors or Master's degree in computer science or equivalent education and experience. 6 - 10 years experience in administering Microsoft SQL server databases. Extensive experience writing T-SQL and stored procedures and query tuning on high transaction systems. Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server Knowledge in DB2, MongoDB, PostgreSQL, Hadoop and database instances in Azure/AWS would be a plus Experienced in SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS). Experienced in ETL (Extract-Transform-Load) development / data integration. Sound knowledge of RDBMS concepts, database architecture and SQL/T-SQL. Proficient with SQL server profiler for monitoring and troubleshooting database activity and performance. Experience in SQL Server Clustering and HA technologies including mirroring, log shipping, failover cluster and various replication technologies would be an advantage. Knowledge of other databases like MySQL, No SQL databases and In-memory databases and MCTIP certification will be an advantage. Ability to develop procedure documents and maintain detailed database related documents. Innovative approach to work, constantly looking for upgrading the system to more efficient and effective new technologies.
Basic Qualification :
Additional Skills :
Rank :A3
Requested Date :2021-03-30


Please wait..!!