← В ленту
Регистрация: 01.06.2023

Hayk Sargsyan

Специализация: SQL Database Administrator

Портфолио

VOLO LLC

• Design data table structures, create and maintain SQL queries, stored procedures, triggers, and views. • Identify any issues related to database performance and provide corrective measures. • Optimize database systems for performance efficiency.

Praemium LLC

• Support, administer, optimize and help expand the Company's SQL Server database environments running on Windows and Azure platforms. • Provide database deployment support for test and production environments. • Diagnose and address database performance issues using performance monitors, SQL profiler, third-party and internal tools; Interact with Windows administrators on Windows server operating systems issues related to databases. • Troubleshoot database production problems and database connectivity issues; Document, define, maintain and enforce policies and standards for database development.

Ucom LLC

• Responsible for IT reporting and data warehouse development, configuration and maintenance. • Responsible for reporting development for internal customer. • Develop regular export data from billing and data warehouse. • Document all necessary procedures and reports. •Develop complex reports; prepare/ process a set of data for cross-checking. •Responsible for IT and billing data monitoring, as well as services creation.

Скиллы

Business object
GIT
JIRA
MSSQL
Oracle PL/SQL
Oracle SQL
Pentaho Data Integration
Pentaho Report Designer
Toad

Опыт работы

Database Developer
с 10.2021 - По настоящий момент |VOLO LLC
.
• Design data table structures, create and maintain SQL queries, stored procedures, triggers, and views. • Identify any issues related to database performance and provide corrective measures. • Optimize database systems for performance efficiency.
Database Developer
11.2020 - 10.2021 |Praemium LLC
.
• Support, administer, optimize and help expand the Company's SQL Server database environments running on Windows and Azure platforms. • Provide database deployment support for test and production environments. • Diagnose and address database performance issues using performance monitors, SQL profiler, third-party and internal tools; Interact with Windows administrators on Windows server operating systems issues related to databases. • Troubleshoot database production problems and database connectivity issues; Document, define, maintain and enforce policies and standards for database development.
Database Developer / Data Analyst
06.2018 - 10.2020 |Ucom LLC
.
• Responsible for IT reporting and data warehouse development, configuration and maintenance. • Responsible for reporting development for internal customer. • Develop regular export data from billing and data warehouse. • Document all necessary procedures and reports. •Develop complex reports; prepare/ process a set of data for cross-checking. •Responsible for IT and billing data monitoring, as well as services creation.
IT Billing Operations Engineer
11.2017 - 06.2018 |Ucom LLC
.
• Support configuration of Billing, IN/VAS and CRM platforms. • Regular billing cycle and invoicing deployed on Oracle DB Implement new products/services based on provide business/technical requirements. • Design and develop features for build and test and deployment systems. • Writing SQL, modify existing PL/SQL procedures and packages. • System analysis and troubleshooting, support to CC agents.
IT Billing Support Engineer
05.2016 - 11.2017 |Ucom LLC
.
• 2nd level troubleshooting and problem solving on trouble tickets in IT Billing. • Identify operational, product and system related problems by observing and studying system functioning and performance results. • Support and consult CC troubleshooting, Call Center and Sales support team. • Work systematically with IT sub-teams and Automation engineer to support in complaints response automatization. • Billing system Users full Administration: creation of roles, modification, and termination. • Provide security codes/passwords, eliminate authentication failures. • Instruct on billing different interfaces utilization and customization.
Billing and Credit control Administrator
09.2014 - 04.2016 |Orange
.
• Check and get validation of monthly invoices accuracy and organize on time delivery to customers insuring delivery address correctness. • Fix customer complaints related to billing and invoicing, balance and customer account related issues/requests ; make respective payment registrations and financial adjustments with respective informing to customers. • Initiate and support implementation of respective customers’ high usage reports, monthly check and appropriate credit limits operations performance. • Perform relevant cross-operations with other teams/departments as a cohesive link action of one chain of customer billing, accounting and invoicing procedures.
Technical Consultant
08.2010 - 09.2014 |Orange
.
• Perform on-site pre-sales and post-sales technical consultancy. • Advise customers on product specifications and installation. • Work with Sales Personnel to provide product, business and technical knowledge in support of pre-sales activities. • Prepare customers' flow daily report, delivering to Shop Manager. • “Orange Care” service consultation: install programs, configure network data, transfer content of old phone to the new one.

Образование

Computer Systems and Informatics (Бакалавр)
2010 - 2015
State Engineering University of Armenia

Языки

АнглийскийСвободно владеюРусскийСвободно владеюАрмянскийРодной