| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Phone: PHONE NUMBER AVAILABLEEmail: EMAIL AVAILABLETechnical Skills Summary:Databases:Database Languages:only)SQL Server2019 /2016/2014/2012/2008AccessT-SQL professional level, SQL*PLUS, PL-SQL, Sybase software(4monthsDatabaseConnectivity:ReportingTools:ETL Tools:DataModeling:OperatingSystems:Web Technologies:Web Server:ExperienceSummary:ADO.NET, OLEDB,ODBCSQL Server Reporting Services (SSRS), Report Builder 3.0/2.0,SQL Server Integration Services (SSIS), SQL ServerDTSToad Data Modeler, ER-Win, Visio, SQL Server DataDiagramWindows Server 2012/2008/2003 including Windows 7/8, UNIX,MS-DOSASP.NET (.Net Framework 1.1/2.0/3.5, 4.0,4.3), ADO.NET, Web Services.IIS: Installation, Configuration, Deployment of Applications, and Program As of database administration experience and 2 years (internship) of successfuldeveloping,testing, implementing, and enhancing numerous applications to meet and exceed cybersecurity needs and business objectives. I plan, research and design durable securityarchitectures for various database servers to harden system, secure database from SQL injections,unauthorized data access and data breaches. Expert knowledge in data masking,encryption and pen testing, has given me an edge to safeguard data in transit and at rest.I know a good backups strategy will help in data security as well as business continuity.Major part of my work has been to keep SQL servers accessible, online and secure bypolicy governance and regular auditing. I work proactively in solving possible issues bysetting up alerts, log monitoring and deploying and upholding a strict access and privilegescontrol policy. Regular scanning and auditing help me in finding DB vulnerabilities,misconfigurations risks of noncompliance. A top-performing Certified Senior SQL ServerDBA/ as SQL Database Administrator/Developer and yearlong exposure to Azure. DatabaseManagement and Development which includes installation, configuration, backup, restoration, HA/DRsolution like Log shipping, Mirroring, Replication, and Clustering and ALWAYS ON. Well versed inupgrading, migration, troubleshooting, supporting clients, Data Modeling, SSIS, Database Monitoring,Performance Tuning, Database Security, Database Programming, Patch Management, managingconcurrent applications (managing Locks, Blocks, and Deadlocks) and using SQL Server.Proficient in Transact-SQL, stored procedures, packages, triggers, views, Constraints, Cursors,functions, deployment and managing related security. Medical office administrationResponsibilities:Modified the application as well as database objects such as stored procedures, views,tables, etc.Performed query performance tuning and query optimization.Maximize the stability, uptime, and performance of databases in the productionenvironmentDBAthrough system monitoring, performance tuning, and routine maintenance tasks suchas indexrebuilds, file compressions, statistical updates, and database consistency checks.Automated backup work for the databases as well as sourcecodes.Involved in database design, development, and administration which includes data modeling (logicaland physical),Implement stored procedures, functions, triggers, views, cursors,CTE, etc.Involved in all phases of SSIS package creation and ETL development as well as SSRS andSSAS development.Create jobs and schedules to automate ETL packages withinSSISResolving tracker items (problems or defects found) related to database admin and others related to ourapplications.Installation, configuration, and testing of Microsoft SQL Server2014.Experienced in troubleshooting database related issues such as administration, performance tuning,query optimization, data transformation, data loading, etc.Analyzed, designed, implemented, and unit tested the application.Troubleshooting applications, databases, and such other data-relatedissues.Monitored and resolved application problems such as input validation, SQL injection, datacleansing issues.Data group Virginiaoctober 2020-2022SQL Server DBA Modified the application as well as database objects such as stored procedures, views,tables, etc.Performed query performance tuning and query optimization,Maximize the stability, uptime, and performance of databases in the production environment throughsystem monitoring, performance tuning, and routine maintenance tasks such as indexrebuilds, file compressions, statistical updates, and database consistency checks.Involved in database design, development, and administration which includes data modeling (logicaland physical),Implement stored procedures, functions, triggers, views, cursors,CTE, etc.Involved in all phases of SSIS package creation and ETL development as well asSSRS development.Create jobs and schedules to automate ETL packages withinSSISResolving tracker items (problems or defects found) related to database admin and others relatedto our applications.Data validationCode reviewerreport optimizerManages validation and testing of security architecture and design solutions, and produces detailedengineering specifications with recommended vendor technologies.Provides management and support the development, testing and operation of firewalls,intrusion detection systems, enterprise malware systems and software deployment tools.Run weekly audit reports, SOD reports and any special auditrequestComplete yearly User/Role Recertification's onSAPCreate/Change/Delete all SAP roles used on a daily basis company wide.As data modeler flowing diagram shows the way information through a process or system. Whichis includes data inputs and outputs, data stores, and the various subprocesses.Education:References: Provided upon request |
