| | | 20,000+ Fresh Resumes Monthly | |
|
|
| | Related Resumes Database Administrator Sql Server Avon, IN Sql Server Power Bi Indianapolis, IN Mainframe, JAVA, SQL, Developer, PMPO, Agile Fishers, IN Customer Service C# Indianapolis, IN Data Entry Asp.Net Mvc Python SQL Greenwood, IN Student Systems Analyst/Full-Stack .Net Developer (SQL/.Net Fram Franklin, IN Customer Service Representative Indianapolis, IN |
|
Click here or scroll down to respond to this candidateName: Aziz KarimEmail: EMAIL AVAILABLEExperience Summary:20+ years of SQL Server and 3+ years of Azure and cloud platform experienceTroubleshooting performance using extended events, dmv, perf monitor, profiler, trace, index tuning and stats.Hands on experience in database design and architecture. Defining keys, indexes, normalization, tables, triggers and partitioningExperience in database consistency, health check, data integrity, data encryption, data audit and compliance.Solid experience in large and high transaction database systemsExperience in SQL Server BI tools including SSIS, SSRS and SSASProficient in PowerShell and automating daily DBA repetitive tasksHands on experience in performance tuning and Resource Governor.Extensive knowledge with disaster recovery, data archiving and standby systemsWork with SQL Server HA including Always on, replication, mirroring, log shipping and clustering.Work with complex T SQL, stored procedures, and reportsExperience in TSQL, Azure SQL, MySQL and very familiar with MongoDB, Postgres and CosmosDB, NoSQL and AWS RDSExperience in azure and AWS migrationExperience in Windows server admin, Active directory, Group policies, DNS, DHCP, SQL Server and network security, 3rd party monitoring tools, health check, protocol security and security patchHands on experience in Azure AD and email security like Mimecast, barracudaHands on experience in endpoint security policies and threat protectionExperience in Ransomware attack and disaster recoveryWorked in an agile and devops environmentEducation:Texas A & M University at Kingsville, TX 1991- 1992Master's degree in chemical engineering major and Computer Science minorBangladesh University of Engineering and Technology, Dhaka-Bangladesh 1985-1989Bachelor's or graduate degree in Chemical Engineering major and computer science minorData Modeling Tool: ERWIN, Visio.Additional Training:Power BI, Endpoint security, Identity, and threat protection, Multi factor authentication, azure cloud, data warehouse, data factory, SQL Server 2022 Administration, Always on Availability, SQL Azure and AWS, and Data factory and data lake, Cohesity, ITIL Foundations, Argos report, DACPACTechnical Skills:Database Management and clients:Database development, management and design starting with SQL Server 6.5 and all the way to SQL 2022. MySQL, puTTY, PostgreSQL, MS AccessProgramming: T SQL, Object-oriented programming with Visual Basic, C, PowerBuilder, MS Access, PowerShell, SharePoint, Linux shell scripint, Agile and devopsSOC against cyber-attack: CrowdStrike, Sentinel one. Knowledge of ISO 27001 SOC controlsMonitoring tools: Azure Monitor, Logic monitor, Cisco USC, Meraki, Nagios, Workspace one, Mimecast, Knowbe4, and VaronisData Monitoring tools: Idera, Confio, Redgate, Sentry one, SQL Performance tools, Profiler, CDC, Query Analyzer, IgniteETL Tools: All BI Tools, Data factory, Data integration SSIS, SSDT, Reports SSRS and Data analysis SSAS.Operating Systems: Windows 2019 and older system administration.Work History:Marian University, Indianapolis, IN Oct 2022 July 2024SQL Server DBA and DeveloperMaintained SQL Server and query performanceCreated financial, census, tax and confidential reports, census report.Database administration and architect by Installation, patching, performance tuning, disaster recoveryAutomated daily jobs. Setup all alerts to monitor 24X7Automated jobs using sftp, SQL Agent job, Task Scheduler and PowerShellColleague system administration. Cloning from prod to test.Monitored and managed the resources proactively. Worked closely with the customer.System administration. Server patch, maintaining certificates, Maintain TLS or SSL patch.Penetration Test, Identify risks, perform risk analysis on SQL Servers.maintained data quality, data consistency and data integrityMigrated database to cloud.BCforward, Indianapolis, IN Aug 2018 Feb 2022Sr Database Admin and IT Operations team leadDesigned and supported a large SQL migration to Azure. Used upgrade advisor.Monitored and troubleshot server and query performance. Used perf monitor, extended events, DMV, profiler etc.Performed and monitored SQL Server best practices, health checks and patches.Proficient in PowerShell, Azure shell, Azure migration and Azure CLIOversaw all systems security including email gateway, DLP, security audit, firewall, end points and data protection.Supported SQL Server 2014 and above. Including installation, patches, configuration, health check, alerts, backup, restore, disaster recovery etc.3 years of experience in various azure technologies (e.g., Virtual Machines, Storage, Network, Azure Automation, Azure Backup and Site Recovery Services, Security) to develop and maintain an Azure based cloud solution, with an emphasis on best practices and cloud security.Pros and cons of all Azure SQL service-related offeringsSupported Active Directory and Email security policy setup using SPF, DKIM and DMARCSupported Azure SQL,mySQL and NoSQL, PostgreSQL, and Cosmos DBDesigned and architected cloud computing services in one or more of the following areas: Security, alerts, Compute, cost, growth, Data and Storage, Networking.Used azure log analytics and monitoring toolsManaged a team of 4 System administrators and Network administrators.Setup endpoint security management, threat protection, Identity and MFA.Supported systems on Azure and hyper V and vSphereSupported Microsoft Dynamics and combining it with erecruit ATS or ERPRemote access managementBloom Insurance Agency, Bloomington, INSr DBA and Developer Dec 2015 Jun 2018Troubleshoot any performance issue and figure out optimal configurations.Setup and managed SQL replicationsMigrated databases from SQL 2005 to SQL 2012 instanceSetup and troubleshoot replicationImplemented NetLib, transparent encryption with key managementSetup a SQL native Column encryption with key rotation and TDEChecked overall SQL server health issue and implemented best practicesSetup Redgate Monitoring and troubleshoot all Redgate issuesInstalled and maintained SQL instances on clustered environmentsCreated and migrated SSIS 2016 packages using Visual Studio 2017, SSDT and SFTPCreated SSRS reports.Used PowerShell script to perform daily maintenance and automated maintenanceSetup Database, column encryption and always encryption for HIPAA complianceWorked with database design. Structure and storageProactively monitored all SQL issuesUsed Redgate and SQL CloneWorked in Agile, Devops and DACPACUsed T SQL to write sprocs, triggers and viewsKey Benefit Administrators, Indianapolis, IN Dec 2014 July 2015SQL DeveloperConverted DTS packages to SSISMigrated databases from older version to SQL 2012Work with Log shipping and replicationWorked with SSRS reports and security. IIS and deployment.Used VB/.NET and TSQL code within SSISConverted data from non-SQL Server to SQL ServerPerformance monitoring and TSQL tuning.Navient (formerly SallieMae) Fishers, IN Nov 2013-Nov 2014SQL DBAMigrating databases for their new split company.Supported SQL Server in a cluster environment. Install, patch, support and manage databases.Supported large databases. Use replication and active passive cluster.Build script to make reports and jobs, alerts, monitor security and other health checksImproved installation process and documenting.Recovered databases from a disaster.Setup CDC and worked with CDCUsed Idera, SQL data collection and my script to monitor disk space, performance counters, security etc.Used SSIS, NetBackup and SQL agent backupUsed Resource Governor and MAXDOPUsed DMV and third-party tools to improve performancePerpetual Technologies, Inc., Indianapolis, IN Oct 2011 Oct 2013Senior SQL Server DBA and SupervisorProvided after-hours support for a client with very high-volume transactions and large-sized databases.Monitored 24/7 activities, DB performance and disk space on highly available cloud serversWorked in a clustered system. Used log shipping and replication and Change data controlUsed DMVs and Ignite to monitor performanceWorked with data Extraction, Transformation and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Data Transformation Services (DTS), creating and deploying packagesExperience in creating and using Stored Procedures, Views, User Defined Functions, Sub-Queries and Joins for complex queries involving multiple tables and Exception Handlers.Proficient in SQL Server and T-SQL (DDL and DML) in constructing Tables, Normalization/ De normalization Techniques on database Tables.Strong knowledge of MS system-based server system administration and storage technology SAN.Supervised a 24/7 on call database support teamManaged a MySQL database and Kayako helpdesk ticketing systemSkilled at assessing client needs, working in groups, suggesting ideas that enhance efficiency and performance, implementing technology solutions, and training end users.Eli Lilly and Company, Indianapolis, IN Aug, 2005 Aug, 2011Senior SQL Server DBAUsed SQL Server Reporting Services SSRS to monitor all servers. Like backup, disk space etc.Developed a PowerShell script to install SQL Server unattended.Worked with Replication and mirroring. Two-way immediate update transaction and merge replication.Monitored and improved performance. Used SQL Server Audit, Perf monitor, profiler, or trace, tempDB and index tuning etc.Setup policy-based monitoring for all SQL ServersPut standard in place to ensure all instances meet the minimum requirementsUsed two-way immediate update transaction and merge replicationSupported many SQL Servers (>700) and big (>100 G) databases.Developed a tool to automatically monitor backup, disk space, change password for sa account and monitor other vital information. Used SQL alert and SQL mail.Upgraded SQL Servers to SQL 2005 and 2008.Used oracle 9G installation, Unix script, RMANMigrated databases between different servers and performed disaster recovery. |
