Amer Albsher

•Expert in enterprise-level DB design, administration, and optimization.
•Advanced in query tuning, index strategy, execution plan analysis, and I/O performance tuning.
•Skilled in HA and DR: Always On, clustering, replication, log shipping.
•Extensive experience in cloud database platforms: Azure SQL, AWS RDS, Cloud SQL.
•Hands-on with database security: TDE, auditing, RBAC, encryption, and compliance frameworks (GDPR, ISO 27001).
•Led end-to-end database migration, consolidation, and upgrade projects with minimal downtime.
•Proficient in T-SQL, PL/SQL, scripting, and automation via PowerShell, Ansible, and CI/CD pipelines.
•Implemented robust backup and recovery strategies with automated DR validation.
•Strong understanding of data modeling, normalization, and schema design for transactional and analytical workloads.
•Deep understanding of storage systems (SAN/NAS), IOPS planning, and disk performance tuning for databases.
•Experience with virtualization platforms (VMware, Hyper-V) and containerized database solutions (Docker, Kubernetes).
•Skilled in OS-level tuning for environments supporting database workloads.
•Involved in network configuration, firewall rules, and load balancer setup for distributed database systems.
•Managed monitoring and observability tools (SQL Sentry, SolarWinds, SCOM).
•Participated in infrastructure capacity planning, resource optimization, and budget forecasting.
•Led cross-functional DBA and infrastructure teams, mentoring juniors and setting performance standards.
•Defined DB architecture strategy, roadmap, and standards aligned with enterprise IT goals.
•Technical lead in major incidents, RCA sessions, and long-term remediation planning.
•Partnered with application, infrastructure, and security teams to ensure end-to-end service reliability.
•Strong in stakeholder communication, reporting, and presenting technical strategies to leadership.
•Experienced in managing vendor relationships, license audits, and support escalations.

• Team Leadership: Lead a team of database administrators and developers in designing,
implementing, and maintaining robust database systems, ensuring team collaboration and
innovation.
• Performance Optimization: Oversee database performance tuning, capacity planning,
and troubleshooting to ensure optimal system performance, meeting service level
agreements (SLAs) consistently.
• Standards and Best Practices: Develop and enforce database standards, guidelines, and
best practices to ensure data integrity and security, while mentoring team members and
providing technical support.
• Cross-Functional Collaboration: Work closely with Solution Architects, DevOps
engineers, and IT engineers to implement new cloud-based or on-premises solutions that
align with organizational needs.
• Backup and Recovery: Implement and manage backup and recovery procedures,
ensuring data availability and disaster recovery readiness.
• Project Management: Manage database-related projects, ensuring timely delivery and
adherence to budget and quality standards. Generate database performance reports for
planning server upgrades and troubleshooting issues.
• System Installation and Design: Install database engines, design, and build databases,
and develop strategies for data acquisition, archive recovery, and database
implementation.
• Data Modeling: Review, develop, and design data models using standard diagramming
techniques, translating logical data models into physical databases that integrate with
existing or proposed data structures.
• Data Warehousing: Set up and maintain data warehouse infrastructure, designing and
implementing databases and ETLs to support business needs.
• Business Alignment: Align data strategy with overarching business objectives such as
improving operational efficiency, enhancing customer experience, and driving revenue
growth. Identify specific use cases where data will be instrumental.
• Infrastructure Assessment: Conduct thorough audits of existing data sources, quality,
and integration capabilities. Assess current data infrastructure components including
databases, data warehouses, and analytics tools.
• Architectural Design: Define data ingestion methods, design scalable and secure storage
solutions, and choose appropriate processing frameworks based on workload
requirements.
• Technology Selection: Decide on deployment models and select suitable database
technologies, cloud providers, and analytics tools based on organizational needs.
• Security and Compliance: Implement robust data security measures, establish access
controls, and ensure compliance with data protection regulations and industry-specific
standards.
• Scalability and Optimization: Design scalable architectures and implement performance
optimization strategies such as indexing, query optimization, and caching mechanisms.
• Disaster Recovery: Develop and test comprehensive disaster recovery plans, ensuring
high availability and continuous service.
• Monitoring and Governance: Deploy monitoring tools to continuously monitor data
pipelines, infrastructure health, and performance metrics. Establish data governance
policies and conduct regular audits.
• Training and Development: Assess and enhance team skills, providing ongoing training
and development opportunities on new technologies and best practices in data
management and security.
• Continuous Improvement: Develop a detailed roadmap for phased implementation and
enhancement of data infrastructure capabilities, fostering a culture of innovation and collaboration.

• Database Administration: Managed the full lifecycle of database systems, ensuring
their high availability, security, and performance across diverse environments including
development, testing, and production.
• Database Design and Implementation: Installed database engines, designed and built
databases, and developed comprehensive strategies for data acquisition, archival, and
recovery to support robust business operations.
• Performance Tuning: Executed performance tuning and optimization of SQL queries,
indexes, and configurations, resulting in efficient and reliable database operations.
• Data Modeling: Created and maintained data models using standard diagramming
techniques, translating complex requirements into effective physical database designs.
• Backup and Recovery Management: Implemented and maintained advanced backup
and recovery procedures, ensuring data integrity, and minimizing downtime through
robust disaster recovery planning.
• Technical Collaboration: Worked closely with solution architects, DevOps, and IT
teams to integrate new cloud-based or on-premises database solutions, enhancing system
capabilities and performance.
• Security Implementation: Applied stringent data security measures, established rigorous
access controls, and ensured databases complied with relevant data protection
regulations.
• Data Warehousing and ETL: Developed and managed data warehouse infrastructure,
including the design and implementation of ETL processes to support data analytics and
reporting needs.
• Monitoring and Reporting: Generated comprehensive database performance reports,
planning and executing server upgrades, and troubleshooting issues to maintain optimal
database health.
• Technical Mentorship: Provided mentorship and support to junior database
administrators, sharing expertise, and fostering a collaborative environment focused on
continuous learning and improvement.
• Disaster Recovery Planning: Developed and regularly tested disaster recovery plans,
ensuring minimal data loss and quick restoration of database services in case of failures.
• Scalable Architecture Design: Engineered scalable database architectures, employing
both horizontal and vertical scaling techniques to manage increasing data volumes and
user demands.
• Continuous Improvement: Regularly reviewed and refined database management
practices, incorporating the latest technologies and industry best practices to enhance
system performance and reliability.

• Database Design and Development: Designed, developed, and implemented database
solutions to meet business requirements, ensuring scalability, reliability, and
performance.
• SQL Development: Wrote complex SQL queries, stored procedures, and triggers to
support application functionality and data manipulation needs, optimizing for
performance and efficiency.
• Data Modeling: Developed logical and physical data models, translating business
requirements into effective database structures, and ensuring data integrity and
consistency.
• ETL Processes: Designed and implemented ETL (Extract, Transform, Load) processes
to integrate data from various sources into data warehouses and other repositories,
supporting analytics and reporting.
• Performance Tuning: Conducted performance tuning and optimization of database
systems, including query optimization, indexing strategies, and database configuration
adjustments to enhance system performance.
• Collaboration with Development Teams: Worked closely with software developers,
business analysts, and other stakeholders to gather requirements, design database
solutions, and ensure seamless integration with applications.
• Database Maintenance: Managed database maintenance tasks including backups,
restores, data migrations, and regular updates to ensure data integrity and availability.
• Data Security: Implemented data security measures such as encryption, access controls,
and auditing to protect sensitive information and ensure compliance with data protection
regulations.
• Documentation: Created and maintained comprehensive documentation of database
designs, processes, and best practices to facilitate knowledge sharing and ensure
consistency in database development.
• Testing and Debugging: Conducted thorough testing and debugging of database
solutions to identify and resolve issues, ensuring high-quality and reliable database
performance.
• Continuous Improvement: Stayed current with emerging database technologies and best
practices, continuously improving database solutions to meet evolving business needs
and technological advancements.
• Support and Troubleshooting: Provided support and troubleshooting for databaserelated issues, collaborating with IT and support teams to resolve problems promptly and
effectively.