Brian Chi Email & Phone Number

San Antonio, Tx, Us

Texas, United States

• Create and configure Logical SQL servers, databases, elastic pools in Azure Cloud. Import and Export data within Azure Cloud environment.• Installed, configured, and maintained SQL Server instances and databases. Performed regular database backups and implemented disaster recovery strategies.• Monitored database performance using native SQL Server tools and implemented optimization techniques to improve query response time. Conducted security audits and implemented access controls to ensure data integrity and confidentiality. Collaborated with cross-functional teams to troubleshoot and resolve database-related issues.• Participated in database upgrade projects and ensured compatibility with existing applications.• Assisted in capacity planning and scalability assessments to support business growth.• Ensuring a successful monitor of resources And Log Analytics Able to configure automatic tuning, recovered azure deleted databases and able to recover databases to a point in time.• Monitoring standby Databases to ensure high availability Setup Database Mail and Operator to alert whenever any automated job fails. Participating in Agile/Scrum calls including weekly sprints and daily standups.• Proficient in resolving tickets and user requests, following change management process using ServiceNow.• Developed effective Database Migration procedures to migrate from on-prem to Azure. • Proficiently configured and managed SQL Server AlwaysOn Availability Groups to ensure high availability and disaster recovery. Implemented synchronous and asynchronous replication, failover policies, and listener configurations for seamless database failover and data protection. • Monitored and maintained AlwaysOn environments, resolving issues promptly to minimize downtime and ensure uninterrupted data accessibility

• Provided 24-hour Production support for mission-critical databases in a complex environment.• Administered, supported, and monitored databases by proactively resolving database issues and maintaining servers.• Carried out Database server installations, patches, and upgrades, including both standalone and clustered server environments. Carried out deployments and post-validation testing.• Managed workload independently but collaborated with colleagues to complete larger-scale tasks in a distributed team environment.• Ensured databases adhere to corporate standards and policies, including database auditing.• Creating and Modifying Tables, Stored Procedures, Views, Indexes, User-defined Functions and Triggers etc. as requirement on SQL Server Environments.• Performed all day-to-day aspects of MS SQL database administration. Responsibilities include database design, installation, configuration, upgrades, security, managing users and logins, performance monitoring and tuning, database availability, backup, and recovery, troubleshooting and problem resolution.• Utilized Microsoft Azure's cloud computing platform to elevate healthcare services and advocate for independent care. • Adhered to Change Control Procedures and developed & executed scripted change requests in accordance with change control procedures.• Optimize SQL Code, as necessary. Use Agile tools and ticketing systems as a queue for work.• Created, administered & maintained SQL Server Databases for Production, Development, Test, and Staging Environment for various groups such as Developer, QA, BA, and User On-Prem to Azure Migration Projects.• Employed Azure's robust and scalable database services, compliance capabilities, and disaster recovery solutions to guarantee the availability and safeguarding of vital patient data.• Effectively harnessed Azure's suite of analytics tools to extract data-driven insights, empowering both healthcare professionals and patients to make well-informed decisions.

Fort Wayne, Indiana, United States

• Monitoring SQL Server activity, identifying and resolving issues, and troubleshooting errors and alerts.• Implementing and maintaining backup and recovery strategies, including backup schedules, storage, and retention policies. Forecasting SQL Server resource usage and capacity requirements and recommending hardware and software upgrades as needed. • Provides Tier 2/ Tier 3 and technical support. Provides general consultation and Deployment activities Technology design teams. Perform database capacity planning, data migration, SQL scripting. Analyze and review the database components of vendor’s software packages. I work with Power Shell, IDERA, and Rubrik. SQL server integration services, ETL, deploy and troubleshooting store procedures. Work with IAAS and PAAS Azure services (cloud infrastructure)

Texas, United States

Design, develop, test, deploy, and maintain databasesImplement database objects and database security measuresEstablish backup and recovery solutions for databasesEnsure high availability of database systemsAutomate tasks in the production environmentSupervise and perform SQL Server 2008 to SQL Server 2016 server upgradesManage change management processes and update statisticsInstitute the maintenance and support of Replication and Log ShippingCreate maintenance plans for index fragmentation and backupsWork with DB2 and adhere to company policies and regulationsIdentify systems for enhancement or modernization through detailed analysisDevelop rules and guidelines for SQL object developmentOptimize indexes and tables, maintain database dictionaries, and schema documentationDesign and deploy data table structures, triggers, functions, stored procedures, and viewsCreate queries and reports, address user needsHandle data requests, resolve database access and performance issuesInterface with various teams to resolve application and database problemsTroubleshoot performance issues, perform tuning and administrationDevelop strategies, maintain databases, and recommend business requirementsUnderstand Enterprise applications and demonstrate good management skillsProvide operational support and troubleshoot DB2 issuesConduct capacity planning, ensure data flow and data integrityCollect data and engage in business correspondenceProficient in Microsoft SQL Server, query tuning lifecycle, performance tuning, information gathering, data management, and reportingExperienced in PowerShell, Azure cloud, T-SQL scripts, Procedure Documentation, SSIS, SSRS, and knowledgeable in RDBMS concepts.

Abu Dhabi, United Arab Emirates

creating and maintaining data back-up for recovery in the event of disasters, database security Upgraded SQL Server 2005 servers to SQL Server 2016 with both In-place and Side by Side Upgrade for new applications in the company. Configure and set up Always On availability groups in a 3-node windows cluster environment.Managed SQL Server installation, Configuration, Security, and maintenance following best practices, reliability, maintain databases Using SQL Server Profiler, Extended Events, Query Store, Database Engine Tuning Advisor (DTA) for performance and other third-party monitoring tools Cooperate with developers when writing complex queries and schema refinement. maintain database response times in 24x7 Production environments by developing automated alert jobs, work according to policies and regulations. Prioritizing and responding to and execute tasks in a high-pressure environment, designing, Configuration, Upgrade MS SQL, support production systems Migration and application of Windows and SQL Patching during scheduled database downtimes after hours to ensure databases are up to date in Virtualized environments Implementation and define a vigorous Backup and Recovery strategies and Capacity planning following the company’s Recovery Point Objective (RPO) and Recovery Time objective (RTO) and the Retention policy, SQL database architecture, technical support Directory, Learn emerging technologies, operating systems, federal regulations, system support, information technology. work according to company policies, collaborates with another employee Recommending and implementing data security by creating users and assigning permissions based on the minimum level of database access the user would need and with tools like Always Encrypted, Transparent Data Encryption (TDE) and Dynamic Data Masking (DDM) to secure clients sensitive data,