What are the responsibilities and job description for the Database Administrator position at Infojini?
Job Description:
• The client seeks skilled SQL - Database Administrator, for SQL Server Applications (Microsoft Business Intelligence Stack (SSIS/SSRS/SSAS)) database administrators for managing administrative operations of client, Data Warehouse, Laserfiche document management and other SQL Server based databases and applications and performing following duties:
• The client seeks skilled SQL - Database Administrator, for SQL Server Applications (Microsoft Business Intelligence Stack (SSIS/SSRS/SSAS)) database administrators for managing administrative operations of client, Data Warehouse, Laserfiche document management and other SQL Server based databases and applications and performing following duties:
Responsibilities:
• Assist in Installing, configuring, maintaining & supporting Microsoft Business Intelligence (MSBI) applications & SQL server databases (Latest versions) in production, development, UAT and test environments.
• Assists in the development of high quality efficient ETL applications leveraging Transact SQL stored procedures and other ETL environments.
• Monitor the SQL Server database/Business Intelligence environment including ETL Jobs, Database Refreshes and Maintenance jobs.
• Perform backup and restore all databases.
• Assist in deploying database scripts requested by the Application Development Team.
• Managing database schemas, objects Tables, Views, Functions, Stored Procedures, Triggers and Cursors using Transact-SQL for various business applications.
• Developing and implementing database security policies.
• Create and maintain reports involving a variety of features using SSRS, Qlik-view and Power BI.
• Error handling and debugging coding issues and troubleshoot production problems.
• Works with the team to create and maintain best-practice standards and procedural guidelines.
Job Requirements:
• Bachelor’s or master’s Degree from an accredited university, or its foreign equivalent, in Computer Science or Information Systems/Technology.
• 8 years of experience performing SQL Server Applications (MSBI, SQL) Database
• Administration on Windows platforms.
• Basic experience in ETL design and development experience working with SQL stored procedures and/or ETL tools such as Microsoft SSIS.
• Must be willing to work in an on-call production support model
• Assist in Installing, configuring, maintaining & supporting Microsoft Business Intelligence (MSBI) applications & SQL server databases (Latest versions) in production, development, UAT and test environments.
• Assists in the development of high quality efficient ETL applications leveraging Transact SQL stored procedures and other ETL environments.
• Monitor the SQL Server database/Business Intelligence environment including ETL Jobs, Database Refreshes and Maintenance jobs.
• Perform backup and restore all databases.
• Assist in deploying database scripts requested by the Application Development Team.
• Managing database schemas, objects Tables, Views, Functions, Stored Procedures, Triggers and Cursors using Transact-SQL for various business applications.
• Developing and implementing database security policies.
• Create and maintain reports involving a variety of features using SSRS, Qlik-view and Power BI.
• Error handling and debugging coding issues and troubleshoot production problems.
• Works with the team to create and maintain best-practice standards and procedural guidelines.
Job Requirements:
• Bachelor’s or master’s Degree from an accredited university, or its foreign equivalent, in Computer Science or Information Systems/Technology.
• 8 years of experience performing SQL Server Applications (MSBI, SQL) Database
• Administration on Windows platforms.
• Basic experience in ETL design and development experience working with SQL stored procedures and/or ETL tools such as Microsoft SSIS.
• Must be willing to work in an on-call production support model