Candidate Information Title Sql Server Azure Target Location US-IN-Indianapolis Email Available with paid plan	20,000+ Fresh Resumes Monthly     View Phone Numbers     Receive Resume E-mail Alerts     Post Jobs Free     Link your Free Jobs Page     ... and much more Register on Jobvertise Free
Search 2 million Resumes Keywords: City or Zip:	Related Resumes Sql Server Power Bi Indianapolis, IN Data Science Sql Server Bloomington, IN Sql Server Power Bi Lafayette, IN Database Administrator Sql Server Avon, IN Scrum Master Azure Devops Indianapolis, IN Customer Service Node Js Columbus, IN SQL Developer Bloomington, IN

Name: Aziz KarimEmail: EMAIL AVAILABLEExperience Summary:20+ years of SQL Server Administrator. 3+ years of Azure SQL, Managed an IT operations team.Proficient in Azure environments (Iaas, Paas, Saas) cost analysis and performanceHands on experience in endpoint security policies and threat protectionExperience with Ransomware attack and recoveryExcellent knowledge of SQL database administration in a clustered and HA environmentSolid experience with very large and high transaction database systemsTroubleshooting performance using dmv, perf monitor, Audit, profiler, trace, index tuning and stats.Experience in SQL Server BI tools including SSIS, SSRS and SSASProficient in PowerShell and automating daily DBA activitiesHands on experience with performance tuning and Resource Governor.Extensive knowledge with disaster recovery, data archiving and standby systemsWork with SQL Server high availability including replication, mirroring, log shipping and clustering.Work with complex T SQL, stored procedures and reportsExperience with Azure SQL, mySQL and very familiar with Postgre and NoSQLExperience with MS Windows server, SQL Server and network security, 3rd party monitoring tools and protocol securityStrong Database design and data encryption experienceExperience with all database consistency and health checksHands on experience in Azure AD and email security like Mimecast, barracudaHands on system windows administration and security patchEducation: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 minorAdditional Training: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 Data factory, Cohesity,ITIL Foundations, Argos reportTechnical Skills:Database Management and clients:Database development, management and design starting with SQL Server 6.5 and all the way to SQL 2019. MySQL, puTTY, PostgreSQL, MS Access, DACPACProgramming:T SQL, Object-oriented programming with Visual Basic, C, Powerbuilder, MS Access, Powershell, SharepointSOC against cyber attack: Crowdstrike, Sentinel one.Monitoring tools: Logic monitor, Cisco USC, Meraki, Nagios, Workspaceone, Mimecast, Knowbe4, Azure, and VaronisData Monitoring tools: Azure monitor, Idera, Confio, Redgate, Sentry one, SQL Performance tools, Profiler, CDC, Query Analyzer, Ignite, Backup Exec.ETL Tools: All BI Tools, Data factory, Data integration SSIS, SSDT, Reports SSRS and Data analysis SSAS.Data Modeling Tool: ERWIN, Visio.Operating Systems: Windows 2019 and older, System administration.Work History:Marian University, Indianapolis Oct 2022  PresentMaintain SQL Server and query performance.Financial, census, Tax and confidential reports, census report.Database administration. Installation, patching, performance tuning, disaster recoveryAutomate daily jobs. Setup all alerts to monitor 24X7Automate jobs using sftp, SQL Agent job, Task Scheduler and powershellColleague system administration. Cloning from prod to test.Monitor and manage the resources in advance. Work closely with the customer.System administration. Server patch, maintaining certificates, Maintain TSL or SSL patch.Setup and create Argos reportsBCforward, Indianapolis IN Aug 2018  May 2022Sr Database Admin and IT Ops team leadDesigned and supported a large SQL migration to Azure. Used upgrade advisor.Monitored and troubleshot server and query performance. Used perf monitor, dmv, profiler etcPerformed and monitored SQL Server best practices, health checks and patches.Proficient in Powershell, Azure shell 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 SQLservice-related offeringsSupported Active Directory and Email security policy setup using SPF, DKIM and DMARCSupported Azure SQL and Familiar with NoSQL,PostgreSQL and CosmosDHands on experience with cloud computing services in one or more of the following areas: Security, alerts, Compute, Data and Storage, Networking.Used azure log analytics and monitoring toolsMonitored cost, growth size in azureManaged a team of 4 System administrators and Network administrator.Setup endpoint security management, threat protection, Identity and MFA.Supported systems on Azure and hyper V and vSphereSupported MS Dynamics and combining it with eRecruit ATSRemote access managementBloom Insurance Agency, Bloomington, INSr DBA and Developer Dec 2015  Jun 2018Troubleshoot any performance issue and figure out optimal configurations.Migrated 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 SQL instances including clusterCreated SSIS 2016 packages using VS 2017, SSDT and SFTPCreated SSRS reports.Use Powershell script to perform daily maintenance and automate maintenanceSetup Database, column encryption and always encryption for HIPAA complianceWorked with database design. Structure and storageProactively monitored all SQL issuesPracticed disaster recoveryUsed SQL CloneWorked in Agile and Devops technologyUsed T SQL to write sprocs, triggers and viewsKey Benefit Administrators, Indianapolis, IN Dec 2014  July 2015SQL DeveloperConverted DTS packages to SSISMigrate databases from older version to SQL 2012Work with Log shipping and replicationWork with SSRS reports and security. IIS and deployment.Use VB/.Net and TSQL code within SSISConvert 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 very 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.Used Idera, SQL data collection and my script to monitor disk space, performance counters, security etcUsed 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 afterhours support for a client with very high-volume transactions and large size 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 requirementsExcellent knowledge of SQL Server High availability, Clustering and Mirroring.Used two-way immediate update transaction and merge replicationSupported large number of 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. Perform code review.Maintained SQL Server security. Monitored and implemented.Migrated databases between different servers and performed disaster recovery.