استخدام Database Administrator
شرح موقعیت شغلی
● Working closely with the Basic Software Group (BSG) manager and internal customers to design, install and maintain basic software services such as Database, Data Warehouse, Application Servers, and Report Servers.
● Monitoring services, including OS (Windows and Linux), Databases (MSSQL and MySQL), Application Servers (Microsoft and Tomcat), and Report Servers (SSRS and Power BI).
● Managing the database aspects of the reporting and analytics platform(s) to ensure that reporting jobs are successfully run and analytics data aligns with timeliness/completeness requirements.
● Creating, and modifying the database structure, as necessary, from information given by application developers.
● Working on the database to ensure that the database and data warehouse is tuned for optimal performance.
● Working with business analysts and project managers to develop and refine reporting and analytics requirements.
● Ensuring that the physical designs for the data warehouse and its data structures align with IT strategies, architecture frameworks, and logical data models.
● Planning for backup and recovery of database information.
● Troubleshooting technical issues, finding the root cause, and designing, proposing, and implementing solutions.
Requirements
● Experience with Microsoft Data Analysis and modeling tools (SSIS, and SSAS).
● Experience with application servers (Microsoft and Tomcat).
● Experience with management of reporting services like as SSRS and Power BI.
● Good experience in query optimization and performance tuning.
● Experience using any Source Control Software like Team Foundation Server.
● Experienced in using any Agile Project Management tool like JIRA.
● Monitoring services, including OS (Windows and Linux), Databases (MSSQL and MySQL), Application Servers (Microsoft and Tomcat), and Report Servers (SSRS and Power BI).
● Managing the database aspects of the reporting and analytics platform(s) to ensure that reporting jobs are successfully run and analytics data aligns with timeliness/completeness requirements.
● Creating, and modifying the database structure, as necessary, from information given by application developers.
● Working on the database to ensure that the database and data warehouse is tuned for optimal performance.
● Working with business analysts and project managers to develop and refine reporting and analytics requirements.
● Ensuring that the physical designs for the data warehouse and its data structures align with IT strategies, architecture frameworks, and logical data models.
● Planning for backup and recovery of database information.
● Troubleshooting technical issues, finding the root cause, and designing, proposing, and implementing solutions.
Requirements
● Experience with Microsoft Data Analysis and modeling tools (SSIS, and SSAS).
● Experience with application servers (Microsoft and Tomcat).
● Experience with management of reporting services like as SSRS and Power BI.
● Good experience in query optimization and performance tuning.
● Experience using any Source Control Software like Team Foundation Server.
● Experienced in using any Agile Project Management tool like JIRA.
مهارتهای مورد نیاز
- Databases
- Sql Server
- oracle
- SSIS
- SSAS
حداقل سابقه کار
- کمتر از سه سال
جنسیت
- مهم نیست
وضعیت نظام وظیفه
- مهم نیست