Amir Younas

Experience

• 

  MTBC Careers

  Jun 2011 - Jan 2013

  Database Developer/DBA

  ▪ Installation of SQL Server Software and Related Products.▪ Establish and Maintain Backups on Local and Remote Media.▪ Performance Monitoring and tuning Using Performance Monitor, DBCC Commands, MaintenancePlans, Third Party Tools.▪ Analyze Applications Performance Using Query-Execution Plans, Index Utilization and ProcedureCache Utilization.▪ In Database Programming, Use of Indexes, Normalization Techniques, Execution Plans, T-SQLand Stored Procedures.▪ Plan Growth and Changes (Capacity Planning) with Team.▪ Database design development, Tune Database, Queries Optimization of SQL Server, StoredProcedures and SQL Scripts.▪ Monitor Application Related Jobs and Data Replication Activities. Show less

• 

  Network Centric Solutions

  Mar 2013 - Mar 2015

  Database Consultant

  Oracle Responsibilities▪ Creates and maintains all databases required for development, testing and production usage.▪ Performs ongoing tuning of the database instances▪ Install new versions of the Oracle RDBMS and its tools and any other tools that access the Oracle database.▪ Plans and implements backup and recovery of the Oracle database.▪ Implements and enforces security for all of the Oracle Databases.▪ Performs database re-organization as required to assist performance and ensure maximum uptime of the database.▪ Administers all database objects, including tables, clusters, indexes, views, sequences, packages and procedures.▪ Implement and maintain database security (create and maintain users and roles, assign privileges) Setup and maintain documentation and standards SQL Server Responsibilities▪ Installing, Configuring, Patching and Upgrading SQL Server Software and Related Products.▪ Maintaining Servers and Databases running on them.▪ Configuring and Maintaining database mirroring.▪ Creating and Maintaining Database Log Shipping.▪ Configuring and managing SQL Server Cluster.▪ Monitoring and maintaining of failover cluster.▪ Creating jobs for different task (backup, maintenance etc…).▪ Monitoring performance, server disk space, monitoring logs, ensuring jobs has run successfully, checking for errors. Show less

• 

  HUAWEI

  Apr 2015 - Aug 2018

  DBA

  Responsible for production database with SQL Server 2012▪ Managing and configuring SQL Server AlwaysOn Availability.▪ Writing complex queries for manual reports and pulling on demand data.▪ Writing complex queries for export data.▪ Monitoring real time database performance and health.▪ Monitoring storage and removing and shrinking unnecessary data..▪ Working with end users and cooperate executive to identify business process and application requirements.▪ Available for on call support and response to any emergency.▪ Responsible for managing and configuring active directory.▪ Managing security and administering user and permission for os and database.▪ Managing and maintaining AD Services.▪ Managing and Maintaining User security and permission both AD and Databasaes.▪ Monitoring Storage. Show less

• 

  Wisemani

  Sept 2018 - Aug 2021

  Database Team Lead

  ▪ Responsible for production, development, test environments with SQL Server 2016. ▪ Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security. ▪ Apply data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations. ▪ Help developers to write optimize query and tune existing queries/procedures. ▪ Independently analyze, solve, and correct issues in real time, providing problem resolution end-toend. ▪ Perform backup and recovery and schedule automated jobs. ▪ Refine and automate regular processes, track issues, and document changes. ▪ Assist developers with complex query tuning and schema refinement. ▪ Manage user’s security control access permissions and privileges. ▪ Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues. ▪ Carry out capacity planning requirement analysis. ▪ Work closely with IT project managers, Developers, ETL and BI Programmers. Show less

• 

  CareCloud

  Sept 2021 - Apr 2024

  Manager Database

  Maintain overall ownership of the company databases across all divisions.Responsible to manage all data imports, exports, queries, reports related to all acquisitions, internal, external programs/software.Responsible to develop reconciliation procedures with the Finance, Operations and other related departments.Responsible to supervise functions including troubleshooting, performance tuning, up-grading and systems management in production, test, and development environments making sure that they perform as per expectations and industry standards.Liaise with colleagues in Development, Operations and Infrastructure to ensure optimum service performance and availability.Responsible for database expansion planning by studying and analyzing requirements, advising and convincing senior management and getting it implemented.Maintains database performance by identifying and resolving production and development problems.Keep senior management informed by preparing reports on system performance and problems.Responsible for creating and maintain training culture for database team members for their constant improvement. Show less

• 

  Datamatics Technologies

  Mar 2024 - now

  Database Consultant