Senior Database Architect
FINCA Microfinance Bank Limited
Total years of experience :11 years, 2 Months
Develop strategy for provisioning, maintaining and securing corporate-wide variety of database platforms i.e. (MS SQL Server, Oracle, MySQL, IBM DB2, PostgreSQL).
Formulates and define SLAs and SOPs relating to database administration service delivery.
Established HA & DR for all financial environments to maximize uptime of 99.999% of database environment.
Ensure compliance, uniform and transparent database system across the enterprise.
Establish and enforce standards, best practices and escalation policies to meet SLAs and performance goals.
Review database design, system integration, security, backup recovery and high availability and make recommendations for improvements and enhancements.
Manage and supervise subordinates to ensure activities completed to render end to end continuity services, resource balance and system documentation.
Demonstrated ability to successfully manage, lead and mentor a team of technical professionals.
• Proactive and diligently identified performance bottlenecks for improvements via architectural changes including OS & SQL Server configurations, RAID configurations for SAN, Re-write code logic to break down badly designed tables and implement Microsoft best practices to provision SQL database for client acceptability on system.
• Provide 24x7x365 database administration support for major projects that considered as golden feather in company’s cap.
• Analyze supply chain processes from application to database end to fix anomalies that cause to degrade performance.
• Migrate OnPrem SQL Server database of 400 GB to Azure cloud using MSAsset service with 0% downtime.
• Setup disaster recovery for production databases using always on availability groups as primary site is in Florida that considered as always risky due to hurricanes.
• Strong experience to work with delimited files, perform data validations and loading into database through SSIS.
• Strong knowledge of data warehouse concepts including star schema, snowflake schema and fact-constellation schema.
• Formalize end-to-end Enrollment Cube (DWH) requirements by reverse engineering to existing EDW physical data model designed with SAP Power Designer.
• Filled Enrollment Cube (DWH) data mart from source with conjunction of business analyst team to offload reports as per business needs using Kyubit Business Intelligence suite.
• Perform data reconciliation to ensure that information loaded in dimensions and fact is reliable and accurate.
• Drive Power BI data visualization project to create and maintained various analytical KPIs dashboard to slice and dice data.
• Proven experience to build attribute relationships, associations, hierarchies, MDX queries and manipulation of multi-dimensional data using SSAS cube.
• Extensive experience to enforce business rules, checks and constraints to automate complex processes using triggers, cursors, stored procedures, CTEs and functions.
• Implement logging mechanism in SSIS to verify data records before and after incremental load.
• Arrange In-house trainings to guide developers to leverage benefits to improve performance of system from newly introduced features in SQL Server 2016.
• Collaborate with Infrastructure team to lay down database infrastructure according to Microsoft practices for optimal results.
• Facilitate SCM team to align all database SDLC environments to mitigate development efforts.
• Implemented hybrid data synchronization using ETL scripts and SQL native replication to tackle business scenario.
• Create technical blueprints, artifacts and proposed solution architecture diagrams.
• Optimize SSIS Packages for long running ETL workloads.
• Ability to work closely in direct coordination with company VPs and client nominees.
• Act as liaison with all business stakeholders for alignment on database support and services.
• Conduct gap analysis on existing database infrastructure to improve highly interoperable performance, availability, security and real time reporting to render reliable services to establish harmony between people and government information systems.
• Ensure adherence to key regulatory demands through deployment of GDPR compliant database security for audit purpose.
• Worked on database infrastructure expansion to bridge new counties, districts and cities data with existing government MIS.
• Focusing and participating to prototype new SOPs and refine existing processes to mitigate database infrastructure downtime.
• Empower business users understanding to interact with database system by arranging pre-implementation workshops and providing user-friendly material.
• Define SOPs in collaboration with higher management to provide access for consuming database services and exchange of data with other government entities and business stakeholders.
• Optimized database infrastructure to reduce cost in terms of licensing cost, disk space and memory up to 35% after placement of hardware benchmarking w.r.t Microsoft best practices in existing infrastructure.
• Involved in code reviews before promoting code to production environments.
• Headed a team of 11 IT Coordinators appointed in different district service centers for rendering smooth database services.
• Flexible, enthusiastic, positive mentorship and growing mindset team player with solid communication and leadership skills to lead tasks to meet the SLA beyond that to develop creative business continuity solutions.
• Planning, designing, installation and configuration of Microsoft SQL Server 2012/2014/2016/2019 to support highly optimized, scalable, reliable, secure and strategic database infrastructure.
• Deployed GDPR security compliance for SQL Server to adhere security standards for various industry spanning Banking, Insurance, Public Sector, Education, Retail and Healthcare.
• Implement proactive health check reports on SQL server production environments to audit resource utilization and issue fixing beforehand occurrence.
• Sound experience to migrate databases from other heterogeneous environments such as Oracle, MySQL, DB2 as well as migration from on-promises to cloud (Azure and AWS etc.)
• Develop custom utilities (SSRS Report Killing, Bulk Script Execution and Unattended Installation Bundle) to mitigate manual database administration efforts.
• Setup and configured alerts on production environments for vigilant monitoring of server resources, jobs and critical processes.
• Proven experience to setup and configure high availability and disaster recovery solution using MSSQL native capabilities such as Always on Availability groups, Mirroring, Log Shipping, Replication and SQL clustering.
• Extensive experience to optimize system performance by identifying IO, Network, CPU, Memory, Instance Configuration, Blocking and Deadlocks bottlenecks with SQL native tools SQL Profiler, Performance Monitor, Trace, XEvents, SQL tuning advisor and DMVs.
• Proficient in query optimization by evaluating indexes, statistics, revamp database design, table partitioning, execution plans and logical joins to gain performance up to the mark in accordance with defined performance benchmark.
• Managed 150 SQL instances with 45 TB size using SQL CMS register for 24x7x365 production support under strict SLA.
• Hands on experience to synchronize schemas and data across different SDLC environments using Import/Export, ETL and schema comparison tool from visual studio.
• Experience to implement encryption, compression, maintenance plans and audit policies.
• Develop SSIS packages for data ingestion. Utilize SSRS and SSAS to cater reporting needs.
• Working experience of DBCC commands, proxy account setup, contained databases, CDC, temporal tables, Column Store Indexes and DB Mail.
• Extensive experience to design backup recovery strategies to ensure point in time data availability in case of disaster.
• Experience of installation, configuration, security, troubleshooting and administration of SSRS, SSIS and SSAS server.
• Proficient in creating, designing, developing, configuring and deploying SSIS packages to carry out ETL workloads for data standardization processes.
• Enforce best practices to create T-SQL queries readability, normalization, revamp badly designed tables and re-write poor code in collaboration with development to improve performance overheads and delays.
• Vigilant research on index usage, statistics, table partitions and bad performer query execution plans to optimize system response by eliminating inefficiencies.
• Extensive experience of unit testing to developed artifacts of database code objects, SSIS packages, SSRS reports to deliver high quality solutions.
• Hands on experience to maintain logging information of SSIS packages, SSRS reports and database objects for audit purpose using different error handling mechanisms e.g. windows event logs, text files, trace files, triggers and database tables.
• Maintain code releases in TFS and SVN to keep record of code changes with respect to baselines.
• Provision database infrastructure with AWS services EC2, S3, Glaciers, VPC, ELB, Route53, RDS, IAM, Cloud Formation and SNS.
• Provide support to developers, business users and vendors for resolution, escalation and root cause analysis to remediate potential issues associated with database environment.
• Capable of forming and maintain positive and productive working relationships across the teams.
• Install, configure, patch and cloning of Oracle Applications 11i and R12 instances.
• Create users, roles and assign appropriate privileges on database level.
• Setup hot and cold backup mechanism for point in time recovery.
• Develop Kourne, Bourne and Perl scripts to schedule maintenance cron jobs.
• Develop script to kill hung sessions on database tier that cause to lock operations on database.
• Administration and maintenance of concurrent managers, OHS managers and oracle application server 10g.
• Apply patches for bug fixing and product enhancement on application and database tiers.
• Perform system administration tasks to prepare environment for Oracle Applications.
• Hands on experience to allow authorized access on remote terminals (Putty, VNC etc.) to mitigate security risks on Linux.
• Beginner level knowledge of oracle high availability architecture RAC and data guard Implementation.
• Monitoring Oracle Applications to ensure smooth running of daily activities for 24x7 productions.
• Thorough documentation of all deployments and their respective policies and procedures.
• Technical assistance to developers and consultants during project implementation on all DBA’s related issues.
Data Warehouse Project
URL removed due to policy violation. Please contact support for further information.