HAYK SARGSYAN
Glendale,CA
Summary
Results-driven Database Developer/Administrator with over 7 years of experience in crafting, implementing, and overseeing powerful database solutions. I bring proven expertise in fine-tuning database performance, ensuring rock-solid data security, and optimizing ETL processes for seamless operations. My strength lies in collaborating seamlessly with cross-functional teams to achieve business goals and elevate system efficiency.
Overview
8
8
years of professional experience
Work History
Database Developer
VOLO LLC
10.2021 - 11.2023
- Developed and maintained database solutions to meet organizational requirements, ensuring optimal performance and data integrity.
- Collaborated with cross-functional teams to analyze business needs and design database structures tailored to specific applications.
- Implemented database security measures, including user access controls and encryption, to safeguard sensitive information.
- Conducted performance tuning and optimization to enhance database efficiency, resulting in a 20% reduction in query response time.
- Designed and executed database backup and recovery strategies, ensuring data availability and disaster recovery preparedness.
- Provided technical support and troubleshooting for database-related issues, resolving critical issues promptly to minimize downtime.
- Conducted regular database audits and implemented data cleansing processes to maintain data accuracy and consistency.
Database Administrator
Praemium LLC
11.2020 - 10.2021
- 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
- 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/Data Analyst
Ucom LLC
06.2018 - 10.2020
- 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 set of data for cross checking
- Responsible for IT and billing data monitoring, as well as services creation.
- Designed, developed, and implemented ETL processes to extract, transform, and load data from various source systems into the data warehouse
IT Billing Operations Engineer
Ucom LLC
11.2017 - 06.2018
- 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
Ucom LLC
05.2016 - 11.2017
- 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.
Education
Bachelor of Science - Computer Systems And Informatics
State Engineering University Of Armenia
06.2015
Skills
- Microsoft SQL Server
- Database Design and Modeling
- SQL Development: Query Optimization, Stored Procedures, Triggers, Views
- Data Warehousing: ETL Processes, Dimensional Modeling
- Backup and Recovery: Database Backups, Restoration, Disaster Recovery
- Performance Tuning: Query Optimization, Indexing, Database Profiling
- Oracle PL/SQL
- Pentaho Report Designer/Data Integration
- Business object
- Version Control: Git
- Toad
- JIRA
Timeline
Database Developer
VOLO LLC
10.2021 - 11.2023
Database Administrator
Praemium LLC
11.2020 - 10.2021
Database Developer/Data Analyst
Ucom LLC
06.2018 - 10.2020
IT Billing Operations Engineer
Ucom LLC
11.2017 - 06.2018
IT Billing Support Engineer
Ucom LLC
05.2016 - 11.2017
Bachelor of Science - Computer Systems And Informatics
State Engineering University Of Armenia
Similar Profiles
Linda HamillLinda Hamill
Office Manager at Stone Horses By Volo ArtemOffice Manager at Stone Horses By Volo Artem
Berkan DiktaşBerkan Diktaş
R&D/Physics Engineer at VOLO Composite SolutionsR&D/Physics Engineer at VOLO Composite Solutions
Vivek PranavamurthiVivek Pranavamurthi
Social Host and Sales Rep at Volo SportsSocial Host and Sales Rep at Volo Sports